Returning Value if Criteria falls w/i range Solved/Closed

Question

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. 


Configuration: Windows XP / Firefox 4.0.1

rizvisa1 · Answer

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))

Returning Value if Criteria falls w/i range

1 response

Similar discussions

Subscribe To Our Newsletter!