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

Cecilia wrote:
>
> 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!

--

Dave Peterson