=INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0))

where A2:A6 contain the headers

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"jhg1226" wrote in message
...
I have succesfully created a MAXA formula which retrieves the highest value
in a column of numbers. I would also like to have the label for that
highest
number to appear as well. Can this be done?

Example:
Apples 4
Pears 6 MAXA returns the value 8 but I want the column heading
as well.
Oranges 8
Plums 3