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 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