Hi Folks
Two Workbooks - WB1 and WB2
Formula to go in WB1 J2
I want to look up Col J in WB2 to find the highest value then return the values from Cols A:I from the same row of the highest value into the same Cols in WB1
Cheers
hammer
Hi Folks
Two Workbooks - WB1 and WB2
Formula to go in WB1 J2
I want to look up Col J in WB2 to find the highest value then return the values from Cols A:I from the same row of the highest value into the same Cols in WB1
Cheers
hammer
Hammer - post your worksheet. In the meantime sounds like a index(match(max())) scenario to me - where you want to get the row number of the max value
Happy with my advice? Click on the * reputation button below
match column with max value.xlsx
Hammer, this might get you going. If you want help or I've misunderstood the issue send through your file
Thought I would not need the Samples for this one but anyways please find WB1 and WB2
Requirement is noted in WB2
Cheers
hammer
Try Below formula in A2 of WB2 and copy towards right
=INDEX(WB1.xlsx!A$2:A$8,MATCH(MAX(WB1.xlsx!$J$2:$J$8),WB1.xlsx!$J$2:$J$8,0))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Put this in A2 of the WB2 work book and copy across
=INDEX(WB1.xlsx!A2:A8,MATCH(MAX(WB1.xlsx!$J$2:$J$8),WB1.xlsx!$J$2:$J$8,0))
[EDIT] I see NFLSales jumped in. Same solution
Last edited by Crooza; 04-04-2015 at 04:08 AM.
Great work again Lads
Many thanks
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks