Web to make a multiple dependent drop down list in excel, this is what you need to do:
How to create drop down list in excel with multiple columns. Make sure the “show input message when the cell is selected” box is checked. Web on the data tab, in the sort & filter group, click advanced. Web list the items for the dependent list, and then select the cells.
On the second sheet, create the following named ranges. Web go to the data tab and click on data validation in the data tools group. Web to do this, click the “input message” tab on the data validation dialog box.
With the cells selected, go up to the. =list!$f$3:index (list!$f$3:$f$9,countif (list!$f$3:$f$9,”?*”)) this formula gives a range that has all the names in column f. Set up the first drop down the main dropdown list is created with exact.
On the first sheet, select cell b1. This places the cells in a group so that you can name the group. In the dialog, set allow to.
On the ribbon, click the data tab, and click data validation.