Reference the higest value

[jmj713]

I tried several different formulas I found here with no results. What I'm
looking for is a formula that will return me the name of the highest value.
Let's say in A we have a list of days, Monday through Friday, and in B we
have numbers. If Thursday has the highest number, what kind of formula would
only return "Thursday" back, not the value itself?

 

[Mike H]

Try this

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

Mike

 

[jmj713]

Thank you! That works flawlessly.

To get the second highest, third highest, etc., how do I modify this
formula? Or do I need an entirely different one?