nature969
Board Regular
- Joined
- Dec 20, 2016
- Messages
- 55
Hi all
I am stacking with this vlookup. what I want to do as below
if supplier name (in column A) says ABC ltd take part number in column B for lookup. if supplier name isn't ABC ltd use part number in column C for lookup.
so column E & F is my data source for look up.
Can anyone help me with a formula ?
Thanks
I am stacking with this vlookup. what I want to do as below
if supplier name (in column A) says ABC ltd take part number in column B for lookup. if supplier name isn't ABC ltd use part number in column C for lookup.
so column E & F is my data source for look up.
Can anyone help me with a formula ?
Thanks