Forum Discussion
Solved
OFFSET Formula Error
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?
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.
2 Replies
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.
