I put your example table, including the 3 header rows, in cells
A1:D11. I used B20 to enter the speed (with the label "Speed" in A20),
and B21 to enter the radius (with "Radius" in A21 and "e" in A23), and
then put this formula in B23:

=INDEX(A4:A11,MATCH(B21,INDIRECT(CHAR(65+MATCH(B20 ,B1:D1))&"4:"&CHAR
(65+MATCH(B20,B1:D1))&"11"),-1))

This will cope with data out to column AA (instead of D1 in the
range), and if you have data below row 11 then change the two 11s to
suit.

Hope this helps.

Pete

On Nov 27, 3:08*pm, dksaluki wrote:
I'm having trouble looking up a value in my table. Here's a small
portion of my table and what i'd like to do:

* * * * * *15 * * * 20 * * * *25
e * * * * mph * * mph * * mph
(%) * * *R (ft) * *R (ft) * *R (ft)
1.5 * * *932 * * 1640 * * 2370
2 * * * * 676 * * 1190 * *1720
2.2 * * *605 * * 1070 * * 1550
2.4 * * *546 * * *959 * * *1400
2.6 * * *496 * * *872 * * 1280
2.8 * * *453 * * *796 * * 1170
3 * * * * 415 * * *730 * * *1070
3.2 * * *382 * * *672 * * * 985

What i'm trying to do is lookup a speed across the top, then depending
on what speed, go down until i find my given radius, then depending on
what the radius is, slide across to the left to find out my final e%.

For example if my speed was 20 and my radius was 1070, my e% would be
2.2. But now how do i use the lookup when my speed and radius might be
different?

Any help would be greatly appreciated!!! I've tried MATCH() and HLOOKUP
() combo, but don't always know what columns to look down.

Thanks,
DK