Changing First dropdown list affects the first selcted value in Second dropdown List

[PodsZen]

Hello All,

I have an excel sheet where I have 3 dropdown lists:

1. The first one (A) have value 0 or 1 for example
2. Second one (B) has a list of elements
3. Third one (C) Has the same list of (B)

I have a condition to respect :

• If (A)=0 both dropddown (B) and (C) should show the same selection list .
• If (A)=1 DropDown (B) should show the normal list but dropdown (C) should show the same selected value in (B) and only the selected value ( Do not show all the other list values).

I tried using this condition on the (C) dropdown cell using Data validation :

=IF( Cell(A)=1;Select Cell B ; select all the range of the list values )

But the problem comes up when I select value1 for example in Dropdown C and then change the selection of A=0 to A=1 , and then I select in B Value2 , The Dropdown C still shows Value1 but when I click on it , I find in the list only Value2 ( but what it shows is Value1 eventhough it is not selected).

How can I solve this situation ? and directly show the correct value in C ?

Thank you