Looking up a dollar amount between two column

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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)