cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 179
I am being sent table in followoing format
I want to lookup based on name and color.
Do I use a vlookup with offset?
Index and match?
ColA COLB
John
Red 12
Blue 324
Pink 34
Paul
Green 1234
Red 1121
Any help is always greatly appreciated
I want to lookup based on name and color.
Do I use a vlookup with offset?
Index and match?
ColA COLB
John
Red 12
Blue 324
Pink 34
Paul
Green 1234
Red 1121
Any help is always greatly appreciated