tier pricing

[billburr]

Using Excel, I want to look up a garmetn name in column A, then return a cost
per product from column B, C, or D, based on tier quantities purchased.
Example: In one cell(A1) I know the garment , in another cell (A2) I know
the quantity purchased.

Garment 1-23 24-49 50-100
Shirt $5 $4 $3
Pant $10 $9 $8

What formula looks up the garment shirt or pant, then returns price per item
based on second value(quantity)

[Aladin Akyurek]

Change the headers first to:

Garment,1,24,50

then invoke, assuming that A1:D3 houses the table including the headers:

=INDEX($B$2:$D$3,MATCH("Shirt",$A$2:$A$3,0),MATCH(28,$B$1:$D$1,1))


billburr wrote:
> Using Excel, I want to look up a garmetn name in column A, then return a cost
> per product from column B, C, or D, based on tier quantities purchased.
> Example: In one cell(A1) I know the garment , in another cell (A2) I know
> the quantity purchased.
>
> Garment 1-23 24-49 50-100
> Shirt $5 $4 $3
> Pant $10 $9 $8
>
> What formula looks up the garment shirt or pant, then returns price per item
> based on second value(quantity)

[Arvi Laanemets]

Hi

Something like (on fly):
=OFFSET(PriceTable!$A$1,MATCH($A$1,PriceTable!$A$1:$A$1000,0),MATCH($A$2,{1;
25;51},1))


Arvi Laanemets


"billburr" <[email protected]> wrote in message
news:[email protected]...
> Using Excel, I want to look up a garmetn name in column A, then return a
cost
> per product from column B, C, or D, based on tier quantities purchased.
> Example: In one cell(A1) I know the garment , in another cell (A2) I know
> the quantity purchased.
>
> Garment 1-23 24-49 50-100
> Shirt $5 $4 $3
> Pant $10 $9 $8
>
> What formula looks up the garment shirt or pant, then returns price per
item
> based on second value(quantity)