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