Assuming your data in A2:C3, and your criteria in E2


=LOOKUP(E2,A2:A3,C2:C3)



"tveith" wrote:

I have a chart 1 that has a list of ranges and if the number falls with in
the range I want the commision value returned to my new work sheet
ex:
Chart 1
Col A Col B Col C
500 599 50.00
600 699 55.00
if the calculated total on my seperate worksheet A is between 500 599 I want
the 50.00 to pull to worksheet A.
--
Tammy