How To | Create Dependent Drop-down Lists in Excel

Learn how to dynamically change list in one drop-down list based on value selected from another drop-down list. example of that could be selecting department in the first drop-down list and the second drop-down list immediately start showing only employees in that department.

The way we are doing it, adding new items to the master list make the new item available immediately in the drop-down menu selection without having to change the range inside the name manager! it is a big-time saver! Hope you Like it!

[vintagevic]

Thank you, this is superb. I was able to follow along even though I have a much older version of Excel on a Mac. This is the best explanation I have found.

[jefffrazier]

I created a very complex spreadsheet that accomplished exactly what you explained in the video, but your version was much more effective, less time-consuming, reduces formulas and thus file size. When I get back to work, I will begin to incorporate what I have learned here. THANK YOU SO VERY MUCH.

[pisces.]

This is the easiest tutorial i found on dependent drop down list without blanks! “Indirect” is way easier than “index”

[atulmeshramkar]

Thank you Abdallah for showing how to do this practically. Great Job.! Helped me a lot.

[charlesamone]

This is Recommendable, its Going to help me a lot thanks

[centpenny]

THANK YOU!!!! Exactly what I needed and so useful. Excellent video with clear understanding.

[LusoCMD]

Great explanation and you made it so simple. Thanks!

[thresiapather]

Thanks so much for an easy to understand presentation....from an absolute novice!

[pisces.]

This the easiest and fastest tutorial on dependent drop down without blanks. Thank you for this video! ☺️
Liked, and subscribed. Even added the alarm for new videos.

[bimkumsen]

Dear sir, i watch many excel videos for years, today by chance i found your video which is unique navigation list, where i can look into menu of items to choose. it very simple but dynamic for my job. Keep up great work, i shall subscribe to learn more from you.Great Job!

[omprakashram]

Very helpful, presented in a very simple and understandable manner!

[Dawn]

Best explanation and easy steps to follow - thank you so much!

[pnamajck]

i enjoyed your tutorial, *abdallah* … 'specially with regard to the _"indirect"_ function. you explained yourself almost exactly the way i explain myself … when instructing someone.
 
in the next few weeks … will try implementing _"dependent drop-down lists"_ within *libre-office* or *numbers* _(mac-os)_ … who knows, i might come away with a bit of luck.

[alm]

This is a fantastic and simple to follow video!! Thank you very much for this guidance.

[addbotjaforms]

been searching everywhere and i found the answer on your video thanks!!!

[thegingerbreadman]

Amazing stuff! thank you very much for the video. It was really helpful

[chafikzitoun]

Thanks. Really, it helps me great tutorial

[wergilius]

Still valid in 2019, thank you! If you want to use space or other letter in the main drop down list, you can replace them in the indirect selection:
=INDIREKT(BYT.UT(BYT.UT(B10;" ";"");"+";"")) (adapt to your language INDIRECT and SUBSTITUTE)
This removes any spaces and + in table header, but still visible in drop down list. Remove the same letters in the name definition.

[Marina-mjwu]

I looked at so many videos to learn this. This one explained it so easily and in the shortest amount of time! Great video

[syuhadanazri]

Thank you so much! This is very helpful!