Manual Mode: Script Mode: It will select the option at the given index. Example 1: If we want a select 'Feb' from the below drop down then we will pass input 2 in the value.Here in this example, we are Validating verify Option Selected By Index Also.Example: We have a drop-down and want to get the total number of available options in a drop-down then we will use 'get Number Of Total Option'.As it has 5 options in the dropdown it will return a value 5.This allows users to choose from a list rather than having to type any information directly into a cell, maybe incorrectly.The simplest way to do this using the Data Validation options is pointing the source of the list to some cells that having the information in them.Now that this is setup, you can add new rows to the Departments table, and they will automatically show up in the Data Validation dropdown list.8 minutes A drop-down list (abbreviated drop-down; also known as a drop-down menu) is a graphical control element, similar to a list box, that allows the user to choose one value from a list.
Now that the table is setup with a descriptive name, you can reference the table using this name.
Because of this, we have to include the INDIRECT function as well.
The image below shows you the arguments dialog box which gives a brief description of the function.
To reference a specific table column you can use the following method.
Table Name[Column Name] In our example, you would use the following.