Forum Discussion
Anyone know how to make a dropdown list dependent on the contents of 2 other dropdowns?
SergeiBaklan I stumbled across this post from over two years ago and it fits an issue I am trying to resolve as well. I followed the listing.xls file you posted but the dropdown in column C does not appear to be working. Something seems to be wrong with the data validation in that column as none of the Barangay dropdowns work. Do you know what needs to be fixed in the validation formula for this dropdown? Id like to apply the concept to a Dependent Validation drop down table I have setup but cant get it to work.
For last 3 cells I use named formula for data validation and it works. For thirst 3 it is direct formula and it doesn't work after re-opening.
Will play some more with that, but later.
SergeiBaklan Thanks for the prompt reply. I am office 365 for the Excel version. Ill take a look at the updated file today. I did some searching yesterday on it and it appears Arrays cause problems in the data validation. They work while the file is open after you enter the formula. But if you save and close, then reopen the file, it no longer works.
Yes, exactly the same issue on some other files. But that's not only on Excel with Dynamic Arrays, I checked on semi-annual version (pre-DA Excel) - same story.