Create Multiple Dependent Drop Down Lists in Excel

Create multiple dependent drop down lists in Excel. Each lists options are dependent upon the previous list selection.

It is vital for your Excel reports that data is accurate. Assist users when entering data by providing drop down lists of the possible options. If you have large lists of options then break it down into several cascading drop down lists.

To create multiple dependent drop down lists in Excel you will first need to set up your lists as named ranges. The Data Validation tool and the INDIRECT function can then be used to reference the named ranges creating dependent lists.

*** Online Excel Courses ***

Join the Audience:

View more awesome FREE Excel tips

[Octrooi]

4 years later, and still the best explanation!
Sir I salute you, thanks for saving/helping!

[johnt]

This is the ONLY video on youtube about this topic that made sense. You explained it and walked us through EVERY step. Thank you very much

[shrutisuryanarayana]

I wanted to create a very detailed expense chart but didn't know how to create dependent lists. Thanks to you, i did it in just a few minutes. The way you explain stuff is very good, even someone with very less excel knowledge can do it easily.

[willjones]

You are an absolute hero. I know this is an old video but I want you to know that this brilliant work is still being used today. Thanks for your help

[vincerivas]

Very helpful video! I was personally experiencing an issue with a dependent list I had created, in which I had a bunch of blank cells after each list. Your demonstration on use of the name ranges in the indirect formula helped to resolve this. Much appreciated!

[sabenaedwards]

Thank you soooo much!!! I have now been able to make my bra sizing calculator the way that I want it, I have learned more valuable knowledge about excel functions, and completed all of this before having to cancel my free trial of Microsoft Office. Total Score!

[lfltube]

I'm so happy I have learned this amazing solution. For some years I've been struggling with work around works, never satisfactory. Thank you so much for this video. Channel subscribed!

[leebakerman]

You're a life saver! I have tried so many other ways (interesting logically, but total wastes of time)... and this was so simple! Thanks.

[ThomasParkes]

Wonderful video, you saved my life, and you explain it much easier than others.

[nishthaaiyer]

got a better working than what you had shown. Thanks for this

[martinbrady]

Brilliant explanation. Everything you need to know how to do it simply. Thank you

[tgriffin]

Thanks for this! Much easier to understand than other examples that I have seen around!

[ridelrio]

Very helpful! I am taking a complex course on financials and this will help me break down my reference guides!!!

[arnisdaddy]

Beautiful video! Very concise and well explained. You solved a problem I previously thought might be unsolvable. I will probably owe you a new car after I get my spreadsheet up and running, since it will be used for making me a lot of money. Thank you so much!

[christaylor]

THANK YOU for this video! I was able to create my first MDDL by watching this. VERY informative, nice, easy & calm walk-through. 👍👍

[davemonaghan]

Actually understandable presentation very well explained and not assuming viewer has extensive experience with subject matter, like most other presentations on this subject. Thanks for help.

[dawncyrikcaparas]

OMG! I have struggled with this for quite some time! I've been working on my spreadsheet for 3 hours! you are amazing!

[lliinnkkxx]

Best tutorial regarding the subject so far...Thanks a Lot!

[AdChaFF]

Great Video Sir! I have been struggling to get my list to work correctly and the "$" tip is probably the key! Learned 2 new things. Thanks for this video.

[Sixpot]

Excellent explanation. This really helped me today - I was going stir crazy trying to make this work today because I wasn't removing the dollar sign. Many thanks!