I am recieving a #N/A in the field. This is what it looks like now that I
modified it to fit what I am doing. Can you see what may be wrong? $E$8 is
the lookup value and the table is in $P$2:$Z$41.

=INDEX($Q$3:$Z$41,MATCH(ROUND($E$8,1),$P$3:$P$41,0 ),MATCH($E$8-ROUND($E$8,1),$Q$2:$Z$2,0))
--
Thank you!


"Glenn" wrote:

Doug wrote:
I have a lookup table that I need to reference. based on a 3 digit # such as
"2.22", I need to be able to find the cross section on the lookup table.
Based on numbers across the top and down the left side;
If I have the number 2.22, it will return for me .15 from the table

lookup table (made up values)
.00 .01 .02 .03 .04 ... .09
2.0 .31 .32 .33 .34 .35 ... .50
2.1 .21 .35 .51 .51 .25 ... .85
2.2 .53 .52 .15 .52 .51 ... .81
2.3 .89 .58 .23 .45 .15 ... .15


http://www.contextures.com/xlFunctio...ml#IndexMatch2

Assuming your table above is in A1:K5, and 2.22 is in A10, try this:

=INDEX($B$2:$K$5,MATCH(ROUND(A10,1),$A$2:$A$5,0),
MATCH(A10-ROUND(A10,1),$B$1:$K$1,0))
.