| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Dependent dropdown list is something that keeps-on changing its items based on a change in the value of another dropdown.
Execute the following steps to create these dependent dropdown lists. 1 Name the range A1:A3 as Food. 2 Name the range B1:B4 as Fruits. 3 Name the range C1:C4 as Vegetables. 4 Name the range D1:D3 as Meat. 5 Select cell D3 and go to Data Validation menu in the Data tab and click on Data Validation. 6 In the Data Validation window, select “List” from the dropdown. 7 In the source section, type “=Food” and click on OK button. 8 Select the cell G3 and go to Data Validation menu in the Data tab and click on Data Validation and repeat step 6. In the source section, type “=INDIRECT(D3)” and click on OK button. financial modeling consultant |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependant Dropdown lists using Combo Boxes | Excel Discussion (Misc queries) | |||
| CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL | Excel Worksheet Functions | |||
| select dropdown list dependant on value of a given cell | Excel Discussion (Misc queries) | |||
| Excel 2003 - Customise a Data Form for dropdown lists | Excel Discussion (Misc queries) | |||
| how do I add data validation dropdown lists to a Form | Excel Worksheet Functions | |||
Threaded Mode
