search from range in column 1 and print from corresponding values

M

manu

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

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table and value range 2
Vlookup or Match 1
Locating values in a range and bringing up the corresponding price 3
Finding the corresponding value in a range? 4
Summing Contiguous Values in a Column? 6
finding is a value is betwen a range of values 5
Excel Formula 8
Column Heading on each row in pivot table 1

Top