search from range in column 1 and print from corresponding values
column 1 column 2
0-100 2
101-200 4
201-300 6
301-400 8
401-500 10
I need a formula that would look whether a no. entered in a cell falls in
which range in column 1 and print the corresponding value in column 2.
|