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.
|