Try this

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

Mike

"jmj713" wrote:

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?