Hi,
If I have understood it correctly

=HLOOKUP(VLOOKUP(A10,A10:H10,5,FALSE),B10:H11,2,FA LSE)

This will give you the output 12


Hope this will help you.

Thanks,

Shail


Intermediate Excel User.... wrote:
I am trying to find a way for excel to do a vlookup (or something like it)
coupled with an hlookup (to obtain a result).

Here's an example table:
Results
Group 1 0.0% 72.0% 74.0% 76.0% 78.0% 80.0% 82.0%
0.0 8.0 10.0 12.0 14.0 16.0 18.0
Group 2 0.0% 74.0% 76.0% 78.0% 80.0% 82.0% 84.0%
0.0 8.0 10.0 12.0 14.0 16.0 18.0
Group 3 0.0% 74.0% 76.0% 78.0% 80.0% 82.0% 84.0%
0.0 8.0 10.0 12.0 14.0 16.0 18.0

In a separate tab, I have the group name (eg. Group 3) and a result value
(eg. 78%). I'm trying to create/find a formula that will read the Group
name, then read the result, go over to this table (which is on a separate
tab) and have it locate Group 3, and do an hlookup for the result of 78 and
return me the value of 12. the above table is not a PivotTable.

I originally thought I could use a vlookup coupled with an hlookup but I
can't get that to work. Any suggestions?