Returning Value if Criteria falls w/i range

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to create a spreadsheet that will lookup and return the value from column C, when the given criteria falls between columns A and B ie if I type 1,260,000 into a cell, I then want the next cell to return the corresponding value from column C - 27.3%.

A B C
1,250,001 1,500,000 27.3%
1,500,001 1,750,000 38.5%
1,750,001 2,000,000 46.7%
2,000,001 2,250,000 52.6%

Any help would be greatly appreciated.


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use lookup

some thing like this

=VLOOKUP(D1,A:C,3)
D1: cell where you are typing the value
A:C : same as your columns

one catch is that if i type some thing less than 1,250,001 , then it will return error. You can trap it too by use of some thing like this
=IF(ISERROR(VLOOKUP(D1,A:C,3)),"",VLOOKUP(D1,A:C,3))
thank you, much appreciated.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you are very welcome