Go to the data tab and click on data validation.

How to create drop down list in excel with multiple criteria. In the “source” input type “=indirect ($b$1)”, where $b$1 is the name of the cell. Web select “data validation” in the “data tools” section. In the dialog, set allow to.

We will put most of the stuff here. Select all other cells where you want the dependent list to appear (c4:c12) and press. First of all we type selected row in.

Create a new sheet and name it calculations. Web to do this, click the “input message” tab on the data validation dialog box. First, create the first, second and third drop down list data as below screenshot shown:

Select the list in allow option in validation criteria.