How to Create a Dependent Drop Down List in Excel (Step-by-Step Tutorial)

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
Workbook Download: Follow along with the exact same workbook I'm using by downloading it here: https://1drv.ms/x/s!AmxrofZZlZ-whdt5C...

⌚ 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
Playlist with all my videos on Excel:    • ❎ How to use Excel  

📩 NEWSLETTER
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
Official website: http://www.kevinstratvert.com
LinkedIn:   / kevinstratvert  
Discord: https://bit.ly/KevinStratvertDiscord
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  
TikTok:   / kevinstratvert  
Instagram:   / kevinstratvert  

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | https://grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut | https://bit.ly/installcapcut
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | https://psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr

🎒 MY COURSES
Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?...

🙌 SUPPORT THE CHANNEL
Hit the THANKS button in any video!
Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ 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