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.