This solves the problem as described, but my other questions are still
relevant.

=INDEX($A$2:$A$13,MATCH($T$1,$B$2:$B$13,1))+INDEX( $B$1:$E$1,
MATCH(MIN(INDEX(ABS(OFFSET($B$1:$E$1,MATCH($T$1,$B $2:$B$13,1),)-$T$1),)),
INDEX(ABS(OFFSET($B$1:$E$1,MATCH($T$1,$B$2:$B$13,1 ),)-$T$1),),0))

Steve D.


If T1 was
"Steve Dunn" wrote in message
...
Hi Doug,

Is there an underlying pattern to these numbers? What is the likelyhood
of T1 fitting exactly between two values, and what result do you want if
it does? If T1 was 0.14235 would the answer be 0.33 or 0.4?

Basically, we need some background information before any reply could be
useful.



"Doug" wrote in message
...
These are the actual values in a portion of a table; If cell "T1" says
".12" I need it to first recognize the closest value, being between
0.1179 &
0.1217. Second, since it is closer to 0.1217 it would return the value
".31".
How can this be accomplished please?

0.00 (0.01) 0.02 0.03
0.0 0.0000 0.0040 0.0080 0.0120
0.1 0.0398 0.0438 0.0478 0.0517
0.2 0.0793 0.0832 0.0871 0.0910
(0.3) 0.1179 (0.1217) 0.1255 0.1293
0.4 0.1554 0.1591 0.1628 0.1664
0.5 0.1915 0.1950 0.1985 0.2019
0.6 0.2257 0.2291 0.2324 0.2357
0.7 0.2580 0.2611 0.2642 0.2673
0.8 0.2881 0.2910 0.2939 0.2967
0.9 0.3159 0.3186 0.3212 0.3238
1.0 0.3413 0.3438 0.3461 0.3485
1.1 0.3643 0.3665 0.3686 0.3708

--
Thank you!