Dependent dropdown list

[jo83]

Hey.

I would like to create a dependent dropdown list.
There would be two dropdown lists and depending on what will be chosen in the first one, the options in the second one should change accordingly.

Here is an example:

So List 1 includes 3 options:
C1.01 Apples
S1.02 Organge
F1.03 Banana

If someone chooses "C1.01 Apples", then List 2 would display 4 options:
CD1.01.01 Process xx
CD1.01.02 Process yy yy yy
CD1.01.03 Process zz zz zz
CD1.01.04 Process oooo

And so on.

	A	B	C
1	List 1	List 2
2	C1.01 Apples	CD1.01.01 Process xx
3		CD1.01.02 Process yy yy yy
4		CD1.01.03 Process zz zz zz
5		CD1.01.04 Process oooo
6
7	S1.02 Organge	S1.02.01 Process dd ddd
8		S1.02.01 Process sdser
9		S1.02.01 Process wen dmowd
10
11	F1.03 Banana	F1.03.01 Assist dwd dwe
12		F1.03.01 Assist dd dd dd

<tbody>
</tbody>

I would very much appreciate some help with it.

Thank you very much!
Cheers

 

[AlphaFrog]

Here's a pretty good step-by-step guide w/video and sample file to create Dependent Drop Down Lists

 

[jo83]

Hey, Thank you very much for the link.
Unfortunately on the site/video they have a have an exact mach of names: Name of range in list 2 has exactly the same name as an entry in list 1.
However in my case the entries in list 1 have spaces between and therefore i cannot give the same name to a range in list 2.

Do you maybe know how to go about it?

Jo

 

[Jim885]

Hey, Thank you very much for the link.
Unfortunately on the site/video they have a have an exact mach of names: Name of range in list 2 has exactly the same name as an entry in list 1.
However in my case the entries in list 1 have spaces between and therefore i cannot give the same name to a range in list 2.

Do you maybe know how to go about it?

Jo

Take a closer look at the video AND the instructions for multiple drop down lists on the lower section of the web page. It DOES contain all the information you need, and has an identical set up as to what you want/need.

Also ... at the bottom of the web page AlphaFrog provided to you, there is the ability to download sample files of the drop down lists that you could alter with your data. That would work! Right?

Here' s another video that might help you.

Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Dependent DV - YouTube

 

[AlphaFrog]

What Jim885 said. More specifically, see these sections near the bottom in the link;
Using Two-Word Items
Using Items with Illegal Characters

 

[jo83]

Great. The second video on Youtube had it all!!
Thank you so much

 

[pareshj]

It is very simple to create dependent drop down list in excel. Check out the below link and follow the steps,


Create Dependent Drop-down lists in excel | S&P Infotech Blog