# Returning Value if Criteria falls w/i range

Solved/Closed
kstetner - Jun 17, 2011 at 10:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 17, 2011 at 06:01 PM
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.

Related:

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2011 at 01:10 PM
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.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 17, 2011 at 06:01 PM
you are very welcome