I have a situation where I need to match 2 columns to return a proper value from the 3rd column
Here is an example:
MERCHANT # Plant Add PLANT #
1254443 1645 W SAMHOUSTON PKY N ATTN AP FINE PAPER 0965
1254443 2001 KIRBY DRIVE 4TH FLOOR 0966
I am looking up from one workbook to another and I get a #Ref error. Here is the formula
=INDEX('[Monthly Invoice Line Item Detail - May 2017 (002).xlsx]Monthly Invoice Line Item Data'!$E$3:$E$842,MATCH(C3,'[Monthly Invoice Line Item Detail - May 2017 (002).xlsx]Monthly Invoice Line Item Data'!$C$3:$C$842,0),MATCH(D3,'[Monthly Invoice Line Item Detail - May 2017 (002).xlsx]Monthly Invoice Line Item Data'!$D$3:$D$842,0))
I know the 2nd match should be the column reference, but I can't figure out how to get the 2 columns matched in a single match statement.
Do I need to create a concatenation of the 2 to get a proper match?