Validating drop down
You cannot begin named ranges with a number, or use spaces and some other symbols.
So, if items in your list use spaces, or start with numbers it presents an obstacle.
This is done using the INDIRECT function (Learn more awesome examples of the INDIRECT function).
A common issue when creating dependent lists is the use of illegitimate characters in named ranges.
In this example, we prevent the entry of a future date.
Maybe users are recording a transaction that has occurred.
In the Source box you can type =city to reference the named range.
For the dependent list in cell G2, the selection in cell F2 needs to be converted into a reference to the named ranges.
By using validation rules, we can limit the mistake a user may make.Creating drop down lists is the reason most people become familiar with the Data Validation feature.Creating lists is a simple and effective way of controlling data entry. You can then either type the list items directly into the Source box separated by a comma, or refer to a range of cells that contain the list items.In this example, cell A2 is the upper left cell of the selected range of cells.You can create Data Validation rules that are based on the value from another cell by writing a custom formula.