How to Create a Dependent Dropdown List in Excel

Closed
krishnap2w2 Posts 2 Registration date Friday November 21, 2014 Status Member Last seen December 24, 2014 - Dec 24, 2014 at 05:40 AM
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.

Excel Consultants