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.

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...

  • I found that it actually needed to be =INDIRECT("R1C" & MATCH(MAX(4:4),4:4,0),FALSE) – enano2054 Dec 7 '12 at 22:09
  • 1
    I prefer the INDEX method....but that also requires 0 as 3rd argument of MATCH, i.e. =INDEX(1:1,MATCH(MAX(4:4),4:4,0)) – barry houdini Dec 8 '12 at 0:04
  • @all Thanks for reminding me that there's a 3rd parameter in Match. When I tested it, it seemed to work with just 2 so it simply slipped my mind. I added the 0s to assist future viewers. – Daniel Dec 8 '12 at 0:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.