Excel Data Validation Custom List. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. Create the drop down list select the cells in which you want the drop down list on the ribbon s data tab click data validation.
The data validation window will appear. Select the last option custom formula one and use the formula. To allow a user to switch between two or more lists you can use the if function to test for a value and conditionally return a list of values based on the result.
For this click the data validation button on the data tab in the data tools group or press the key sequence alt d l each key.
To allow a user to switch between two or more lists you can use the if function to test for a value and conditionally return a list of values based on the result. Open the data validation dialog box. In this example we use data validation to create a dropdown list to accommodate limited options and we limit the. Select the last option custom formula one and use the formula.
