Drop-down list varies based on input

[kaldrazidrim]

All fields in column E of sheet 1 have data validation for drop downs from a list that is specified on Sheet 2. This list is called "Major".


The major list is


1- Color


2- Machine Problem


3- Eyemark, etc...


Now I have other lists specified on Sheet 2 called "Minor lists".


If I select "1- Color" from the Major drop-down list in E, I want the adjacent cell in column F to be the corresponding "1- Minor" drop-down list.


If I select "2- Machine Problem" from the Major drop-down list in E, I want the value in F to be a drop down list that corresponds to that value, namely "2-Minor".


In other words, based on the input in E (from a drop-down), I want the value of F to change to various corresponding drop-downs.

 

[VoG]

Take a look at dependent lists http://www.contextures.com/xlDataVal02.html

 

[jeffreybrown]

Cross post

 

[kaldrazidrim]

That's it. Thanks!