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. Go to the Data tab, click Data Validation and set up a drop-down list based on a named range in the usual way by selecting List under Allow and entering the range name in the Source box.įor the detailed steps, please see Making a drop down list based on a named range.Īs the result, you will have a drop-down menu in your worksheet similar to this:.In the same or in another spreadsheet, select a cell or several cells in which you want your primary drop-down list to appear.
When done, you may want to press Ctrl+F3 to open the Name Manager window and check if all of the lists have correct names and references. For example, the dependent list to be displayed when " Mango" is selected from the first drop-down list should be named Mango.
Please pay attention that if your first row is sort of column header like you see in the screenshot above, you shall not include it in the named range.įor the detailed step-by-step instructions please see Creating a named range.
0 kommentar(er)
