The first excel drop down list will set the condition, the region.

How to create drop down list in excel based on cell value. Web we need two excel drop down lists. Web go to the “data” tab in the ribbon. Web select the cell or cells where you want to create a dropdown list.

This allows you to enter data into a specific cell of a. Cell a1 could contain two 3 values, country1,. Web on the data tab, in the sort & filter group, click advanced.

In the menu, under the components section, click “ dropdowns. at the top, click. Web it’s easy and we’ll show you how. Web what i am trying to do in excel is to return a droplist of values depending on the value of another cell.

In the “source” input type “=indirect ($b$1)”, where. The second excel drop down list will display the. Select “data validation” in the “data tools” section.

In the source box, enter the formula that indirectly refers to table1's column named items. Select the range of cells, click copy to another.