Listing the Value Label for highest value

[CraigC]

I have 5 columns containing numbers in which I need the 6th column to report
back the Column Heading of the Cell in the columns 1-5 that has the highest
value.

So, if the headings were North, East, South, West, and Central (in A1-E1)
and Heading in F1 was Highest Value. AND, if the values for A2 t hrough E2
were 96,84, 14, 100,50, the value for F1 would be "West"....

thanks,
Craig

 

[Jason Morin]

One way:

=INDEX(A1:E1,MATCH(MAX(A2:E2),A2:E2,0))

HTH
Jason
Atlanta, GA