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

PodsZen

New Member
Joined
Oct 11, 2021
Messages
1
Office Version
  1. 2016
  2. 2013
  3. 2010
Platform
  1. Windows
  2. Web
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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,772
Messages
5,766,397
Members
425,350
Latest member
procha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top