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