Quote:
Originally Posted by Kinghart
OK Pete....
I have a table like this
< a b c d e
0-0.5 25 26 27 38 48
0.5-1.00 32 34 39 42 49
1.00-1.50 36 39 41 45 52
1.51-2.00 39 43 49 52 56
I want C7 to show 41 when i type 1.10 or 1.30 or 1.49 in B7
I'm using a formula like this:
=INDEX($B$17:$I$19,MATCH(B3,$A$17:$A$19,0),MATCH(F 3,$B$16:$I$16,0))
But that formula only works when i write 1.00 and 1.50 in B7... (not 1.10 or 1.20 or 1.23)
|
BTW. It didn't work Gary.. but thanks