Hi all,
I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it.
I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture:
But then, when I change the value in the first list (parent) the old value previously selected in the second list (sibling) is kept even though it has not been registered as a valid option. I often end up with weird outcomes as the picture below shows:
What I want is that the dependent sibling list (cell G3) goes blank automatically or displays an error message whenever the parent main list (cell F3) is changed. How can I possibly do that?
Big thanks to all!
ps: I'm working with a rather complex data related to my area of study so I made this simple yet helpful example just to make things easier to understand.
I'm somewhat new to this linked drop down lists thing and I'm having a little problem with it.
I was able to make two dependent lists that work really nice when I'm first selecting the options as you can see in this first picture:

But then, when I change the value in the first list (parent) the old value previously selected in the second list (sibling) is kept even though it has not been registered as a valid option. I often end up with weird outcomes as the picture below shows:

What I want is that the dependent sibling list (cell G3) goes blank automatically or displays an error message whenever the parent main list (cell F3) is changed. How can I possibly do that?
Big thanks to all!
ps: I'm working with a rather complex data related to my area of study so I made this simple yet helpful example just to make things easier to understand.