How do I set up a price sheet in excel.

V

Veronica

I need to know how to set up a price sheet that when a customer on line
changes the quantity so does the price.
 
J

Jay

I need to know how to set up a price sheet that when a customer on line
changes the quantity so does the price.
Click to expand...

The example in the CSV file below might suggest a useful approach.

The unit price lookup table might be on a separate worksheet if that's more
convenient.

-------------- cut here --------------
Description,Qty,Unit Price,Subtotal,
Thyme,4,"=VLOOKUP(A2,A$10:B$13,2,FALSE)",=C2*B2,
Parsley,2,"=VLOOKUP(A3,A$10:B$13,2,FALSE)",=C3*B3,
Rosemary,8,"=VLOOKUP(A4,A$10:B$13,2,FALSE)",=C4*B4,

,,,=SUM(D2:D4),="Grand Total"


,Unit Price,,,
Parsley,12,,,
Sage,13,,,
Rosemary,14,,,
Thyme,15,,,
 
Top