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