OFFSET Formula Error

[andrewfeenan]

Hi,

When typing the formula =OFFSET(PictureTable,,,,1) into the data validation pop-up formula box I get the formula error pop-up. 

Does anyone know why?

[#2 · Accepted solution]

@andrewfeenan 

Unfortunately, you cannot use a table name in a data validation formula.

Create a defined name, for example PictureTable1, that refers to =PictureTable.

You can then use  =OFFSET(PictureTable1,,,,1)  in your data validation formula.

[#3]

@Hans Vogelaar 

Thanks for the tip. It's working now