SOLVED

OFFSET Formula Error

Occasional Contributor

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

@Hans Vogelaar 

 

Thanks for the tip. It's working now