In the “source” input type “=indirect ($b$1)”, where $b$1 is the name of the cell.
How to create drop down list in excel with multiple criteria. Web select “data validation” in the “data tools” section. Go to the data tab and click on data validation. On the ribbon, click the data tab, and click data validation.
Select the cells that you want to contain the lists. Select all other cells where you want the dependent list to appear (c4:c12) and press. First, create the first, second and third drop down list data as below screenshot shown:
Make sure the “show input message when the cell is selected” box is checked. Web to do this, click the “input message” tab on the data validation dialog box. We will put most of the stuff here.
Select the list in allow option in validation criteria.