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.

Search for validating drop down:

validating drop down-76validating drop down-18

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “validating drop down”

  1. Lucy, an IBM Programme Manager who met Pete through Parship two years ago, says: “I loved the compatibility test where I then stood a chance of meeting someone who I really was compatible with.