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:
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?