Match Index accross two workbook with certain range of column

[ahmsuza]

I have two workbooks.
One is with single sheet several columns, the other workbook has multiple tabs with company name.
Both workbook has some common data.
Need to match and return result if the payment details found both file.
can someone help?

[Kaper]

You probably can use INDIRECT for this.

[FDibbins]

Keep in mind that INDIRECT() only works on open workbooks. If 1 will be closed, look at using the Morefunc add-in

[ahmsuza]

Thank you for the reply.
In column V of the "WB1" file need to create a new column and fill it with a function that will pull over some type of indication if weather the payment for that row is accounted for on the 2nd spreadsheet called "WB2". This 2nd workbook is separated into Tabs by company and the 4 things that need to be matched up are the Date, First name, Last name, and Amount. i dont believe a vlookup function is appropriate here because this has MULTIPLE CRITERIA in which all 4 fields (columns A B C & D on each tab of "WB2" must match with columns F, D, E, and N on "WB1" and then in line V the formula need to show that it has indeed been found on both. with be in order to confirm each. payment (highlighted in yellow on the WB2) is accounted for on the WB1
I have attached both file for better understanding.
Can you help which function can be put here?