In Cell B4 enter

=Max(B1:B3)

In cell A4 enter

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

" wrote:

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?