I assume you have a list of items which you use to populate the dropdown for
Item. Assume this list is in a sheet named Data and in the column next to
it is the respective price. Assume this list is in Data!A2:B60
under price on your worksheet (assume C2) put in
=if(A2="","",B2*Vlookup(A2,Data!A2:B60,2,False))
Drag fill this formula down the price column.
--
Regards,
Tom Ogilvy
"Jrr6415sun" wrote
in message ...
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
--
Jrr6415sun
------------------------------------------------------------------------
Jrr6415sun's Profile:
http://www.excelforum.com/member.php...o&userid=25064
View this thread: http://www.excelforum.com/showthread...hreadid=385953