Sep 16 2022 03:26 AM
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?
Sep 16 2022 03:46 AM
SolutionUnfortunately, 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.
Sep 16 2022 03:46 AM
SolutionUnfortunately, 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.