Data validation won't allow formulas

[reidpdb]

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]

@reidpdb 

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.

[#3]

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.