Hey folks,
I have a list of numeric values and want to return the value in the column adjacent to it:
ie. Rows H6:H17 contain numeric values
Rows G6:G17 contain names
In cell H20 I'd like a formula that looks up the max value in range H6:H17 and returns the adjacent value from column G.
I've tried this formula:
=INDEX(G6:G17,MATCH(MAX(H6:H17),H6:H17))
but this returns the last value in the range G6:G17. Is there an Offset I could use?
Any help most appreciated as always,
Steve
Bookmarks