Prev: Summing multi-level bill of material
Next: wHY DOES MY CURSOR TURN INTO A CROSSHAIR AFTER I CUT AND PASTE SP
From: tveith on 19 May 2010 22:35
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
From: Teethless mama on 19 May 2010 22:54
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
From: Ashish Mathur on 23 May 2010 02:33
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" <tveith(a)discussions.microsoft.com> wrote in message
news:64830769-145D-460F-973C-BF731AB05CE8(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Summing multi-level bill of material
Next: wHY DOES MY CURSOR TURN INTO A CROSSHAIR AFTER I CUT AND PASTE SP