Looking up a dollar amount between two column

Closed
Dana - May 17, 2010 at 04:57 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 17, 2010 at 05:36 PM
Hello,

I want a cell to look up a value in a table that has three rows of data.

A1 A2 A3
0 10 10.00
11 20 11.00
21 30 12.00
31 40 13.00
ect.....

I want my cell called total, to look at another cell called Price: in this example the vale in Price = 14

I want the cell called total to look at columns A1 and A2 and find where price falls,
in this case Price is 14 so it should see that it is equal or greater than A1, and equal or less than A2, in this example the total shown in A3 would be $11.00

I know this is simple, but I can not get it to work for me. Please help.


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 17, 2010 at 05:36 PM
use vlookup


=VLOOKUP(14,A:A,1,TRUE)

this looks for value in column A and returns the exact value being matched (14 in this case) or the less than it


=VLOOKUP(D2,A:A,1,TRUE)
0