returning a value in a table referencing ranges

[tveith]

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.

 

[Teethless mama]

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


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

 

[Ashish Mathur]

Hi,

Try this

=vlookup(F23,$A$2:$C$6,1). F23 is the calculated total cell. A2:C6 is
chart 1 data

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com