I have a table like this.
begin end answer
..05 .08 1
..09 .16 2
..17 .25 3
I have sheet with information like this
0.03
0.08
0.16
0.195
0.24
I want to look up the number in the sheet and find the range and return the
full number. So .16 would return a two and .195 would return a 3.
Can excel handle this? I could use nested if statements but then formula
gets very long.