display the value of a cell adjacent to the cell with max value

I

Ian

I have a very large spreadsheet that is constantly being added to. I have a
function that displays the max value of a particular column, but I also want
to display the name that coincides with it. Since the name is located in a
different column but same row number, is there a way to display it? (e.g.
A2="Mark", B2=97.8)
Any help would be greatly appreciated.
 
B

Biff

Hi!

Here's one way:

=INDEX(A2:A11,MATCH(MAX(B2:B11),B2:B11,0))

Note: if there is more than one instance of max the formula will return the
corresponding value of the first instance.

Biff
 
Top