Forum Discussion
johnnycasali365
Feb 17, 2022Copper Contributor
Data Validation correct but dropdown list randomly not working
Hi all, the title is pretty self-explanatory. I have a tab with about 30 cells linked to a table in another tab with about 200 references. For some reason, only the first half of cells work corr...
SergeiBaklan
Feb 17, 2022Diamond Contributor
I didn't catch the idea of such data structuring, but the logic of data validation is different for first cells and the rest. In first cells data validation list refers on spill which selects data based on the same cell. Rest of cells has one position shift for spill formula criteria.
- johnnycasali365Feb 17, 2022Copper ContributorYou are absolutely right! Thank you very much Sergei