We will put most of the stuff here.

How to create drop down list in excel with multiple criteria. Select all other cells where you want the dependent list to appear (c4:c12) and press. Web select “data validation” in the “data tools” section. On the ribbon, click the data tab, and click data validation.

First, create the first, second and third drop down list data as below screenshot shown: In the “source” input type “=indirect ($b$1)”, where $b$1 is the name of the cell. Create a new sheet and name it calculations.

First of all we type selected row in. In the dialog, set allow to. Web to do this, click the “input message” tab on the data validation dialog box.

Go to the data tab and click on data validation.