Conditional drop-down list help needed

[tazmusica]

Hi everyone, I am looking for help regarding conditional drop-down lists. Here is the scenario I am looking for:

Cell A1:
Has a drop-down menu defined by Data Validation list from a separate sheet. For the sake of argument, say the choices are "a", "b", "c", "d", "e", "f", and "g".
Cell B1:
If Cell A1 is set to "a" or "b", then B1 equals "N/A" (single string, no drop-down)
If Cell A1 is set to "c", "d", or "g" then B1 is a drop-down menu with choices "t", "u", "v", "w"
If Cell A1 is set to "e" or "f" then B1 is a drop-down menu with choices "l", "m", "n", "o", and "p"

If you have any ideas or suggestions, I would greatly appreciate it. Thank you.

 

[Skybluekid]

If you look up on You tube or Google "dependant drop list", I think this is what you are after.

 

[Skybluekid]

Welcome to the board