Help with drop down menu
 

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

Please see this example:
http://www.officearticles.com/tutori...excel.htm#boss
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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

Have a table of items and prices, and look it up. For example

=VLOOKUP(A1,M1:N20,2,FALSE)*B2

where A2 is the dropdown, B2 is the quantity, and column M lists the items,
column N lists the prices. Also, use column M as the reference list in the
drop-down, for data integrity.

--
HTH

Bob Phillips

"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

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

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