Mary Ann,

In A13, use the formula

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

HTH,
Bernie
MS Excel MVP


"Mary Ann" wrote in message
...
I have a list of people in one column, say A1:A10 with their results in the
next column, say B1:B10. I have calculated the highest result using the MAX
function, located in B13.

I want to show the name of the person who achieved the highest score next to
the MAX function - in my example this would be in A13.

I have been researching Array formulas, which I have some understanding of,
and would have thought I could have used one to give me the result I want in
combination with the IF function.

However, I cannot make it work.

How do I do this? I am a competent user but do not do programming.

I am using 2003.