Forum Discussion
Data validation won't allow formulas
Hello, I am trying to create a drop down list that references a table, however the application is not allowing me to use a formula in the source selection. See below. Any ideas? Thanks, ...
Sadly, it is not possible to use a table name directly in the source of a data validation rule.
Fortunately, there are workarounds:
Use the INDIRECT function: enter =INDIRECT("location")
- or -
Create a named range that refers to the table:
You can then use =location_table as source for your data validation.