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