In the source box, enter the formula that indirectly refers to table1's column named items.

How to create relational drop down list in excel. Here's what we are trying to achieve: Web it’s easy and we’ll show you how. Web on the ribbon, click data > data validation.

In our first criterion, we’ll make. 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. If you don't want users to.

On the ribbon, click the data tab, and click data validation. Web this will create the drop down 1. Web 4 ways to create conditional drop down list in excel 1.

Select the entire data set (a1:b6 in this example). Optionally, you can check the box to. Then, customize the list using the data validation options.

In the dialog, set allow to. Simply click the arrow and select an option.