With your table below in A1:H6 put

=HLOOKUP(B5,INDIRECT(LEFT($A5,5)&RIGHT($A5,1)),2)
in B6 and copy across.

If you can change the name to be 'Group3' rather than 'Group 3' then
you could simplify that formula to


=HLOOKUP(B5,INDIRECT($A5),2)

HTH


On Fri, 1 Sep 2006 03:17:01 -0700, Intermediate Excel User....
<Intermediate Excel 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?

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________