Can I nest Max in HLOOKUP?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi--

I tried to use the following:

=HLOOKUP((MAX(G6:J6)),G6:J6,2:2,FALSE)

What I want to do is pull the highest value in range G6:J6 and have that be
the lookup value to return the column heading that matches the highest value.

Here's what the table looks like:

Age 18 Age 35 Age 55 Age 65 (Row 2)

91 88 117 131 (Row 6)

I would want to identify 131 as the highest value and have the formula
return Age 65.

Thanks so much for your help!
 
I'd use:
=index(G2:J2,match(max(g6:j6),g6:j6,0))
Hi--

I tried to use the following:

=HLOOKUP((MAX(G6:J6)),G6:J6,2:2,FALSE)

What I want to do is pull the highest value in range G6:J6 and have that be
the lookup value to return the column heading that matches the highest value.

Here's what the table looks like:

Age 18 Age 35 Age 55 Age 65 (Row 2)

91 88 117 131 (Row 6)

I would want to identify 131 as the highest value and have the formula
return Age 65.

Thanks so much for your help!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional statement using validation cell 2
Hlookup, range_lookup parameter 1
Hlookup/max value? 4
Trying to find additional ranges outside of min, max, and average 2
Insert value based on range 3
hlookup value within a range 4
HLOOKUP and choose one value among 2 values 1
Nested IF & MAX Function 4

Back
Top