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.

search from range in column 1 and print from corresponding values
 

Hi,

If you change the first column to read
0 2
101 4
201 6
301 8
401 10

Then you can use =VLOOKUP(H1,A1:B5,2,TRUE)

Where H1 contains the number you want to look up and your modified table is
in the range A1:B5.

--
Thanks,
Shane Devenshire


"manu" wrote:

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.