Make a Conditional Drop Down List with Unorganized Data Table Read more: How to Create Dynamic Dependent Drop Down List in ExcelĢ. Now select a smartphone brand from the independent drop-down in Cell C13 and then click on the dependent drop-down button in Cell C14, you’ll find all the smartphone models of the selected brand.Īlter the smartphone brand and you’ll find the corresponding smartphone models only, as shown in the screenshot below. The function will store the smartphone models in arrays for two different brands.

➤ In the Source box, type the following formula:īy using the INDIRECT function here, we’ve mentioned the cell reference of C13. ➤ Open the Data Validation dialogue box again. ➤ Since we have to create a dependent drop-down list in Cell C14 now, select the mentioned cell first. So, we’ve just created two named ranges for two different smartphone brands with their corresponding models. ➤ Put a mark on the first option ‘Top row’ only and leave other options unmarked. ➤ Under the Formulas ribbon, choose the Custom from Selection command from the Defined Names drop-down. ➤ Now select the entire table or the range of cells B4:C11. So, we’ve just created an independent drop-down list for the smartphone brands in Cell C13. ➤ Activate editing in the Source box and select the range of cells (B4:C4) containing the brand names of the smartphones. ➤ In the Allow box, select List from the options. ➤ Under the Data tab, choose the Data Validation command from the Data Tools drop-down. After that, we’ll make a dependent drop-down list in Cell C14 where smartphone models will be shown in a list based on the selected brand from the previous drop-down list. In Cell C13, we’ll create an independent drop-down list for the brand types.

In the picture below, you’re now seeing two columns containing smartphone models of two different renowned brands. In our first criterion, we’ll make a dependent drop-down list from some organized data. Create a Conditional Drop Down List with Classified Data Table 4 Ways to Create Conditional Drop Down List in Excel 1.

How to add drop down menu in excel 2016