Create Dependent Drop Down List in Excel - EASY METHOD

In this step-by-step tutorial, learn how to create dependent dropdown lists in Excel. This feature allows you to select a value in one dropdown list that influences the available options in subsequent dropdown lists. It's an incredibly useful tool for creating dynamic and interactive forms, and I'll show you just how easy it is to set up.

In this tutorial, we'll create an order form for the Kevin Cookie Company, where the items in one dropdown list will filter the options available in another. For instance, if a customer selects "cookie," they'll see all our delicious cookie options, and if they choose "drink," they'll see all our refreshing drink options. We'll also set up additional dropdowns for more specific selections, like coffee types or smoothie flavors.

What You'll Learn:
- How to create named ranges in Excel.
- Setting up the first dropdown list.
- Creating dependent dropdown lists using the INDIRECT function.
- Troubleshooting common issues with named ranges.
- Making your forms more dynamic and user-friendly.

Host: Kevin Stratvert

📚 RESOURCES

⌚ TIMESTAMPS
00:00 Introduction
00:19 Download the workbook
00:31 Background
01:07 Set up a named range
02:57 Set up first dropdown list
04:22 Create dependent dropdown lists
09:04 Troubleshoot named ranges
10:29 Testing the Dropdowns
10:49 Copy dropdowns to multiple rows
11:24 Wrap up

📺 RELATED VIDEOS

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎁 TOOLS AND DISCOUNTS

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel

[CMDai]

8:51 If you want to avoid adding an underscore in "Fruit_Smoothie", make it look more professional/readable, you can add a substitute function to replace the space with an underscore.


=INDIRECT(SUBSTITUTE(B7, " ", "_"))

[heathkarikudenga]

This was the most simplest explanation ever, Kevin is living legen

[tekmepikcha]

KEVIN! This is sooo useful. I recently discovered data validation but had no idea I could make my life easier by naming the drop-down list. Thanks a mill.

[xaquison]

Genius for its simplicity. I was watching your previous video regarding this subject and this last video is a lot easier.

[Stephen_A.]

Congrats on 3 million subscribers ! 🎉

[george-mattgrounder-bentle]

Thanks Kevin! Brilliant way of using indirect method

[VerbaVolantVV]

Name Range is one of the most overlooked features in Excel, yet one of the most powerful/useful of all.

[robertosfsouza]

Thank you Kevin! Brilliant explanation…👏👏👏

[tedmoy]

Great video! I'll need to wait until there's class for intermediate to advanced. Looking forward that class (and that it's not $$)

[mzvtithesleaze]

Clicking the subscribe button from Africa, Malawi

[rockymarquiss]

I submit that rather than creating a Fruit_Smoothie that you put as the source - =indirect(substitute(b7, " ", "_", )) - I also suggest adding headings for each of the other drinks and create a selection with a blank cell - this way on the dropdown it will have a blank cell as (the only) value for Plain Milk or Chocolate Milk selections.

[abg_mok]

thanks for your sharing...appreciate it

[TsayYu]

Simplified and well understood. Thank You for the videos!

[pusparghabiswas]

Very informative! Please make a video about the dynamic dropdown list.

[martyshmanka]

Thanks Kevin. I am working on a food cost software template and this is handy to know.

[VerbaVolantVV]

In Lotus 123 -indirect- was not necessary. I don't know why MS has simplified this function. Same with the "D" functions: Dget, Dsum, etc. They are not dynamic, just useless. Thank you K.

[tomtoktakk]

can you also make a video about facebook ads ? thank you!

[jack-kol]

Hi- the wealth of info you provide in your videos is priceless. Thank you for sharing. Do you know if it is possible to parse full(historical not incoming) email threads ? If it is, do you offer any type of instruction that would cover that subject?

[onchirijames]

SO, if I need training on Power BI, SQL how can I register? Also consider training on XLS forms, creating survey questionnaires in ODK etc.

[dennisallen]

Great video. So now building off this, I want to track quantities. Not just the for this order, but for history. This person orders a regular coffee with 2 sugar cookies, so I add another column for quantity, easy enough. But want to export that information to know how many coffees or sugar cookies or whatever are ordered over the month to see if I should make more or take them off the menu. Just a thought for the next video to build off of.