You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"jamesjohns82" wrote in message
...
Wow, that is great. Thank you very much.

"T. Valko" wrote:

Try this:

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


--
Biff
Microsoft Excel MVP


"jamesjohns82" wrote in message
...
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?