➤ Choose the option ‘List’ in the Allow box. ➤ Select Cell C16 and open the Data Validation dialogue box. It means we’ll select the available RAM first from the drop-down list based on the selected smartphone brand and then the corresponding smartphone models will show up in the second dependent drop-down. We’ll create two conditional drop-down lists here in Cells D17 and D18, one is for RAM and another one is for the smartphone model. In our data table, we’ve added a new column with the RAM header. Construct Multiple Conditional Drop Down Lists in Excel So, our dependent drop-down list is also prepared to display the assigned items.Īlter the brand name from the Brand drop-down and you’ll find the corresponding smartphone models in the Model drop-down list.ģ. With the use of Hash (#) here, we’re defining the spill range starting from Cell C17. ➤ Select Cell F7 and type the following formula: Now, by using the FILTER function, we’ll filter the smartphone models based on the selection of the Brand from the drop-down list and show them in a spill range in Cell F7. Let’s select an option now from the list Samsung. Our independent drop-down list is not ready to show the assigned values. ➤ Enable editing in the Source box and then select the range of cells (E7:E8) containing the brand names. ➤ Under the Data tab, choose the Data Validation option from the Data Tools drop-down. ➤ Select Cell C16 where we have to make an independent drop-down list first for the brand names. Now in this section, we’ll need a helper table where we’ll store the filtered smartphone models based on the selection from the independent drop-down. With this data table, we have to make a dependent drop-down list in Cell C17. They have not been classified into two different lists. In the following picture, you’re seeing the smartphone models of two brands together in a column. Now we’re going to work with a modified data table. Make a Conditional Drop Down List with Unorganized Data Table
Drop down list in excel how to#
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.
0 kommentar(er)
