unique-distinct-dependent-lists1-three-columns

I am beginning to think that you do not know how dropdown boxes work...

IF you have all 3 DDs populated and you change the first one, nothing changes in the 2nd and 3rd ones. YOU have to reselect the 2nd and 3rd DDs, when they WILL show the correct options.


If you want DD 2 & 3 to empty if you change DD1... you need VBA.


For 1010, you expect the ONLY choices in column F to be GC & SC. Look at your data table. Row 4. Yellow. 1010 & MB is listed. Therefore when you select 1010 you get all 3 possible options: GC, SC & MB. If you DO NOT want MB... why is it listed in row 4???

For 1020, same argument. if you DO NOT want KB and mB to be DD choices, WHY are they listed in rows 7 & 8?

Similarly for 1030... it ONLY shows HD in DD2 and shows all 3 in DD3. See the 3 images, as proof.