Hi folks
First Workbook would have:
A1 F1 I1 J1
24-Oct-14 FIGMENT
I want to lookup A1 and F1 in a 2nd workbook-the data in A1-F1 will be in the same Cols but probably in different row numbers to the first workbook.
When matches are found I want to return the data from Cols I:J back to I:J in the first workbook.
So the info in workbook 1 might be found in workbook 2 like this:
A36 F36
24-Oct-14 FIGMENT
Cheers
Hammer
Bookmarks