max in on column, description in another

[sylv1501]

I want to find the highest number in column B and show the name
associated with that number.

A B

John 123
frank 224
joe 110


frank 224 This would show the name and the associated
number.

Is there a function that will do this?

 

[AKphidelt]

In Cell B4 enter

=Max(B1:B3)

In cell A4 enter

=INDEX(A1:A3,(MATCH(B4,B1:B3,0)))

 

[Ragdyer]

How about combining into a single formula:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))