Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with drop down menu data
i am trying to create a worksheet where i am picking items out of
inventory cell "A-1" has drop down menu which i select item (no problem, i can do that) Cell "B-1" is the corresponding price for the item selected in cell "A-1" example: the drop down allows me to select widgets, modifed widgets, budget widgets, or premium widgets. (up to about 30 choices)......the price of widgets is 10.00, the price of modified widgets is 20.00 the price of budget widgets is 5.00 while the price of premium widgets is 30.00 and so on....... how do i get cell "B-1" to display the correct price according to the selection from the drop down in cell "A-1" thanks in advance for any help you may be able to provide WC |
#2
|
|||
|
|||
Hi
you have answers to this from Tom Ogilvy and myself in microsoft.public.excel.programming ... it's not generally necessary to post to more than one group as most of the responders here read multiple groups and it can upset (some of) us if we spend a long time working on an answer only to discover someone else answered the question in a different group :) Cheers JulieD "wilecoyote" wrote in message . 50... i am trying to create a worksheet where i am picking items out of inventory cell "A-1" has drop down menu which i select item (no problem, i can do that) Cell "B-1" is the corresponding price for the item selected in cell "A-1" example: the drop down allows me to select widgets, modifed widgets, budget widgets, or premium widgets. (up to about 30 choices)......the price of widgets is 10.00, the price of modified widgets is 20.00 the price of budget widgets is 5.00 while the price of premium widgets is 30.00 and so on....... how do i get cell "B-1" to display the correct price according to the selection from the drop down in cell "A-1" thanks in advance for any help you may be able to provide WC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms Toolbar vs. Control Toolbox vs. Data Validation for drop dow | Excel Discussion (Misc queries) | |||
drop down menu containing worksheet names | Excel Worksheet Functions | |||
XML Data menu option -- not listed / available. How do you fix thi | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
How do I set up a drop down menu for a validation list? | Excel Worksheet Functions |