I have 3 Excel files. Excel file 1 and Excel file 2 contains:
- Fixed data in column A
- Different values in column H.
Excel file 3 (dashboard) contains the fixed data found in column A of the 2 files, and column B, C, D should return the values of column H.
The data in column A can be moved to different cells so it should search for the exact match regardless of cell.
Excel File 1
Col. A Col. H
Thomas Moore 0
Albert Einstein 23
John Doe 8
Excel File 2
Col. A Col. H
Thomas Moore 10
Albert Einstein 98
John Doe 50
Excel File 3
Col. A Col. B Col. C
Thomas Moore 0 10
Albert Einstein 23 98
John Doe 8 50
Column A (Same values in Excel file 1 and Excel file 2) Column B (Excel file 1 Col H) Column C (Excel file 2 Col H)
In file 3, everytime it matches the exact values in other files Col A, it returns the corresponding value in H (works like a summary worksheet).