C
Corrie
I am trying to match information in multiple columns (lookup value) to
the same multiple columns in the table array. If the combinations
don't match then I'd like the return to be #N/A. I think an example
can better clarify what I'm trying to accomplish because I haven't a
clue whether I can do it...
On the lookup worksheet I have...
A1 B1
12345 Closeout
12345 First Fill
22233 First Fill
22233 Closeout
On table array worksheet I only have one entry.
A1 B1
12345 Closeout
22233 First Fill
I would like the return to be...
A1 B1 C1
12345 Closeout Y
12345 First Fill #N/A
22233 First Fill Y
22233 Closeout #N/A
I would like the lookup value to combine A1 and B1 and look for that
exact combination on the table array worksheet.
This may be very simple but I am stumped.
Any help is greatly appreciated
the same multiple columns in the table array. If the combinations
don't match then I'd like the return to be #N/A. I think an example
can better clarify what I'm trying to accomplish because I haven't a
clue whether I can do it...
On the lookup worksheet I have...
A1 B1
12345 Closeout
12345 First Fill
22233 First Fill
22233 Closeout
On table array worksheet I only have one entry.
A1 B1
12345 Closeout
22233 First Fill
I would like the return to be...
A1 B1 C1
12345 Closeout Y
12345 First Fill #N/A
22233 First Fill Y
22233 Closeout #N/A
I would like the lookup value to combine A1 and B1 and look for that
exact combination on the table array worksheet.
This may be very simple but I am stumped.
Any help is greatly appreciated