This should be a simple extension of Dynamic pulldown Lists, but it isn’t obvious.

I have a simple pulldown list in cell a1, simply a,b,c done through data validation. In cell a3 I created a dependent list so that if I selected “a” in cell a1, I have a pulldown list that read apples, acorns. If I selected “b” the depedent list is bubbles, baskets. I know how to do this. I created a name “a” with two entries apples and acorns and did a similar thing for the name “b.” This all works as advertised.

Here’s the rub. Suppose I select “a” in cell a1, and then apples in cell a3. But if go to cell a1 and clear the contents, the null string, I want cell a3 to also clear. It doesn’t and I can’t figure out how to accomplish this.

The end application is more complex and has several of these situations so that is why I am asking.