Forum Discussion
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...
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.
- You are absolutely right! Thank you very much Sergei
