B
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)
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)