OFFSET Formula Error

Occasional Contributor



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 Replies
best response confirmed by andrewfeenan (Occasional Contributor)


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.

@Hans Vogelaar 


Thanks for the tip. It's working now