0

I have some columns A, B, C, D, E, F, G with some values in the rows below 2, 3, 4. I don't know if HLOOKUP is the correct answer for what I am trying to do but I want to have a function that looks at the values in row 4, finds the highest/greatest value, and then return the column name/label.

I am really rusty with Excel (this is 2011 by the way) so excuse me if it is a noob question. Don't waste your time telling me how easy it was to do. Just show me the solution.

enano2054
  • 147

1 Answers1

2

Here's a way:

=INDIRECT("R1C" & MATCH(MAX(4:4),4:4,0),FALSE)

Here's another:

=INDEX(1:1,0,MATCH(MAX(4:4),4:4,0))

By the way, I was assuming by column name/label that you meant the header row value...

Daniel
  • 664