In the source box, enter the formula that indirectly refers to table1's column named items.
How to create drop down list in excel with if statement. Web go to the “data” tab in the ribbon. In the “source” input type “=indirect ($b$1)”, where. This tutorial demonstrates 5 methods that.
On the data tab, in the data tools group, click data validation. In the data validation dialog. Web select a cell in which you want the dropdown to appear (d3 in our case).
Add another sheet in excel if you don't. Select “data validation” in the “data tools” section.