returning a value in a table referencing ranges
 

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

returning a value in a table referencing ranges
 

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

returning a value in a table referencing ranges
 

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

"tveith" wrote in message
...
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