Possible to "understand and pull" highest value from column B.....

[jamesjohns82]

My questions is this:

Is it possible to understand and pull the highest value from column B, then
"read" across to column A to pull specific name associated with the highest
value.

Column A Column B Column C
George 15 **George** (After understanding
high value)
Mike 12

Effectively I want a formula for excel to search for highest value in column
B, then effectively pull the name associated with the highest value to Column
C.


Is this possible?

 

[T. Valko]

Try this:

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

 

[jamesjohns82]

Wow, that is great. Thank you very much.

Try this:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!