I am trying to create a spreadsheet (see below) so when I create a drop down list, and an item is selected, only the price of the item will appear. This will allow me to come up with a formula using the price only.

For example, on the attached (and also below), I have a booklet with a total price of $25 dollars. I have to show the difference between the new price and the old price (savings). My drop down list would be under "Old Price". I will have several items, each with a different unit price. I have to have a mini description on each price to make it easier for the person filling out the report. So when they select "4pg ($10)" for example, only the $10.00 would pop up on the cell, allowing me to create a formula under "savings".

OR, I could make the "Description" column have the drop down and have each item associated with a price....for example, they would select something like "Booklet 4pg" and the $10.00 would automatically pop up under "Old Price", several cells away.

Either option would work for me, I just dont know how to make either happen. HELP!!!

Project # description Qty total price Old Price New Price Savings
36548 Booklet 100 $25 DROP DOWN $25 (Formula "old price" X "Qty" - "total Price")
4pg ($10)
8pg ($12)
12pg ($14)
12pg+c ($15)


example.JPG