Create multiple dependent drop-down lists in Excel [EASY]

Make 2 AND 3 levels of dependent data validation lists in multiple rows. It's super easy to set up with named ranges.

🕒 TIMESTAMPS
0:00 What are dependent drop-down lists?
0:40 Prepare data (named ranges)
1:15 Insert level 1 drop-down lists
1:47 Insert level 2 drop-down lists
3:34 Dependent drop-down lists in 3 levels
4:03 Level 1 drop-down lists (for 3 levels)
4:17 Prepare data for 3 levels
5:18 Level 2 drop-down lists (for 3 levels)
5:52 Level 3 drop-down lists

👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!

🎁FREE COURSES

🏆PAID COURSES

🧑‍💻HIRE ME AND MY TEAM

[canesantrac]

U are the only one who actualy explained that u need to delete the second dollar sign in order to work! Thanks man!

[BassamThebian]

You are the only one who gave me the answer I need. All were using Excel 2021 and Excel 365

[kimisomelove]

Such a lifesaver, out of all the videos I was trying to search for, glad I found yours, with clear and easier explanation. I appreciate, thank you~

[emmanuelnwankwo]

Bro... thanks a whole lot for this. Easy and straight forward.

[ghodgins]

excellent vid, so well explained and easy to follow. Thank you

[ifcasiaparsiran]

Amazing video. I searched multiple drop-down lists on YouTube. Literally, this is the simplest and most useful one. Thank you very much.

[azhariqbal]

Wow! You taught the easiest and simplest way to create dependent dropdown lists among all the videos I watched. Thank you so very much.

[studenturial]

I was looking for how to drag the dependent drop down for many days, but you solved it in a very simple way. Thanks 👍

[sekhar]

Detailed explanation of the hierarchy selection. Very useful.

Thank you.

[LybidProject]

Noone showed this in such an easy way! Thanks!

[shkcp]

Simple, easy and useful. Happy to subscribe your channel. LOVE

[paulk]

perfect. quick and easy. pay attention to the details

[skepticbb]

Dude I saw one lady do this with a ridiculous compound match formula, then I saw another guy say that we had to use "xlookup" which doesn't even exist in excel 2016 or 2019. This video is the only one that makes sense. Thanks!

[tokdbpf]

OMG this is so easy! I watched so many videos that make it horribly complicated and they just don't work! Thank you! Got it the first time!

[Richkotite]

This was an excellent tutorial ...clearly explained. Well done! works on Mac too.

[littleviceroy]

and Finally sb with a sensible merci beaucoup

[ashokchudasama]

Excellent, Excellent and only Excellent .Great Respected Sirs.

[pi]

Saved my day, thanks, very appreciated :)

[kumaras]

Thank you very much :-) It's working and very helpful.

[rosstucker]

Good Explanation. Thank you.
I found that Excel can be broken into two or more views. IF you did that then you could put the info on a second sheet and show both at the same time further enhancing a student's ability to take your tutorial information and apply it in their real world.
QUESTION: What about when you are inserting a Dependent Drop-Down List into an existing Table?