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
try the below array formula in I1 and drag it to j1
Formula:
=INDEX(Sheet2!$I$1:$J$100,MATCH(1,(Sheet2!$A$1:$A$100=Sheet1!$A1)*(Sheet2!$B$1:$B$100=Sheet1!$B1)*(Sheet2!$C$1:$C$100=Sheet1!$C1)*(Sheet2!$D$1:$D$100=Sheet1!$D1)*(Sheet2!$E$1:$E$100=Sheet1!$E1)*(Sheet2!$F$1:$F$100=Sheet1!$F1),0),COLUMN(A1))
☚ Click ★ just below left if it helps, Boo?ath?
Hi, Refer the test file with formula updated
Hi boopathiraja
So given they are separate workbooks I would replace Sheet2 with the other workbooks name?
Yes, you can change the references
Hi boopathiraja
I cannot get this to work.
Is it possible if you have the time to do 2 separate workbooks with the formulas in for me?
Cheers
HI, create the references to the file with other file opened,
ps...it will not permit me to add to your rep at this time
"You must spread some Reputation around before giving it to boopathiraja again."
Last edited by hammer2; 10-25-2014 at 06:38 AM. Reason: Post message
Many thanks boopathiraja!
I will be able to manage it from here.
Hi thats fine and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks