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.
You are right, third column doesn't work properly. If open data validation settings and Ok list in the cell is shown for a while, after that stop working.
Anyway, that's a bug, so far don't know there. Could you please say me are you on Excel; version with dynamic arrays or not?
Thank you