Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
Drop down menu | Excel Worksheet Functions | |||
Drop down menu | New Users to Excel | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Drop down menu | Excel Discussion (Misc queries) |