For instance, a list of Indian regions should be named "India", a list of Chines regions - "China", and so on.Īfter that, you select a cell for the 3 rd dropdown (C2 in our case) and apply Excel Data Validation with the following formula (B2 is the cell with the second drop-down menu that contains a list of countries): Just remember the 2 important things discussed above, which are essential for the correct work of your cascading drop-down lists.įor instance, if you want to display a list of regions in column C depending on which country is selected in column B, you create a list of regions for each country and name it after the country's name, exactly as the country appears in second dropdown lists. You can make the drop-down list of this type in the same fashion as we've just made a second dependent drop-down menu. Set up a 3 rd dropdown that depends on the 2 nd list If needed, you could add a 3 rd cascading drop-down list that depends either on the selection in the 2 nd drop-down menu or on the selections in the first two dropdowns. Add a third dependent drop-down list (optional) Safely click Yes, and as soon as you select an item from the first drop-down menu, you will see the entries corresponding to it in the second, dependent, drop-down list.ĥ. If cell A2 is currently empty, you will get the error message " The Source currently evaluates to an error. Where A2 is the cell with your first (primary) drop-down list. But this time, instead of the range's name, you enter the following formula in the Source field: Select a cell(s) for your dependent drop-down menu and apply Excel Data Validation again as described in the previous step.
HOW TO MAKE A DROP DOWN LIST IN EXCEL THAT FILLS OUT A ROW HOW TO
If you have items consisting of two, three or more words, please see How to create a cascading dropdown with multi-word entries.