Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

In this video you'll learn the secrets of creating dependent drop-down lists based on column headers. This tutorial is perfect for those looking to enhance their Excel skills, especially in managing lists with text, spaces, or a mix of both.

⬇️ Download the Workbook here: https://pages.xelplus.com/dependent-dropdown-multiple

Key Points:
- Realistic Examples: Learn to create a first drop-down list that mirrors your column headers, regardless of their format.
- Dynamic Second List: Discover how to set up a second drop-down list that dynamically changes its contents based on the user’s selection from the first list.
- Formula-Driven Approach: Understand the use of a formula, rather than a direct reference, to define the contents of the second list.
- Excel's INDEX-MATCH Formula: Master one of Excel's most powerful formulas, INDEX-MATCH, to link your drop-down lists effectively.
- Data Validation Techniques: Explore the steps for implementing data validation and incorporating formulas into your lists.
- Practical Demonstration: Watch the process of setting up these lists in Excel, including tips on fixing cell references for accuracy.

This video builds on the methods shown in a previous video: https://youtu.be/CIJbcBBH88M which showed how to create an Excel dynamic drop-down data validation list that was dependent on the selection of another drop-down.

In that video the first list contained numbers whereas in this video we take a look at a more realistic case where the first list contains text with multiple words and spaces. This approach works if your drop downs are in different worksheets as well.

Check out this video to create drop-down lists on tabular data sets: https://youtu.be/avVLznHODVA
Index Match basics explained: https://youtu.be/F264FpBDX28

My Online Excel Courses ► https://www.xelplus.com/courses/

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel