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,
Ryan
2 Replies
- Try using =$A8:$A9
If that source is defined as a legitimate Excel Table, that reference should expand as new rows get added. I just duplicated that resolution with a data validation of my own. 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.
