Index Match using multiple columns to match against

0

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?

Answer
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login