You can name another range (PriceList), that includes the items, and the
prices.
Then, create a formula to calculate the price when an item and quantity
have been entered. For example, in cell C2:
=IF(OR(A2="",B2=""),"",VLOOKUP(A2,PriceList,2,FALS E)*B2)
Jrr6415sun wrote:
I have made a drop down menu (by defining a name)
I would like to make it so it changes the price in a different column
when i change the drop down menu item
for example i have
ITEM QUANTITY PRICE
i want to make it so that when I choose the item from the drop down
menu and enter in the quantity it will calculate the total price
for example if i choose a boxed pin from the item menu and then type in
2 in quantity i want it to show up as $20 in the price ($10 each)
is there a way to do this?
thanks
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html