Hello,

I am using the following formula to compare each record of column C and D to the entire columns of both C and D in a referenced workbook.

After the comparison is made, if there is a match, records in columns E-G of the main work book will be populated with records E-G from the referenced workbook.


Here is the formula:

=INDEX(INDIRECT("'["&InputCurTaxRates&"]Sheet1'!$c$2:$g$50000"),MATCH($C3&$D3,INDIRECT("'["&InputCurTaxRates&"]Sheet1'!$c$2:$c$50000&!$d$2:$d$50000"),0),2)


Notice that I am using a two-column lookup in the lookup_value parameter of the MATCH function. I have tried to do the same with the lookup_array parameter. However, it is giving me a reference error.

Does anyone have any suggestions?


Thanks!

Channing