Optionally, you can check the box to.

How to create relational drop down list in excel. On the ribbon, click the data tab, and click data validation. In our first criterion, we’ll make. In the source box, enter the formula that indirectly refers to table1's column named items.

If you don't want users to. Web it’s easy and we’ll show you how. Create a conditional drop down list with classified data table.

Select the cells that you want to contain the lists. In the dialog, set allow to. Then, customize the list using the data validation options.

Web just start typing a formula in a cell, select the required range in your table, and excel will create an appropriate structured reference for you automatically based on the. In the dialog, set allow to list. Web on the ribbon, click data > data validation.

Simply click the arrow and select an option. Web this will create the drop down 1.