Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list populates data in another cell
I'm am creating a spreadsheet that has a drop down list to select a specific
product and I want the selection from the list to automatically generate data for that product in another cell. For example: Cell A2 Drop down list will offer: Mirror 1 Mirror 2 Mirror 3 If Mirror 1 is selected I want a certain dollar amount to appear in cell D2. If Mirror 2 is selected a different dollar amount will appear in D2, etc. I've reviewed this link: http://contextures.com/xlDataVal02.html but I'm not sure that is what I am looking for. Any suggestions would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - In cell drop Down List | Excel Discussion (Misc queries) | |||
Dropdown List that populates another column | Excel Worksheet Functions | |||
Select a category from a list that populates related cells | Excel Worksheet Functions | |||
Type data in one cell - and it automatically populates another cel | Excel Worksheet Functions | |||
Selection in 1st list box populates 2nd list box | Excel Worksheet Functions |