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

Dive into the world of dynamic dependent dropdown lists in Excel! Perfect for users who regularly work with unorganized datasets, this tutorial demonstrates how to create dropdown lists that adapt to your data changes. Ideal for those dealing with non-grouped, random data entries.

⬇️ Download the workbook here: https://pages.xelplus.com/messy-list-file

Key Features:
- Dynamic Dropdown Lists: Master the creation of dropdown lists that automatically update as new data is added or existing data is modified.
- Dealing with Multiple Data Instances: Learn to handle datasets where names or items are not grouped but scattered randomly.
- Excel Table Feature Integration: Leverage the power of Excel tables for expanding dropdown lists, ensuring new names or items reflect in your dropdowns seamlessly.
- Formula-Driven Approach: Explore complex formulas that make these dropdowns possible, ensuring a dynamic and responsive data management experience.
- Step-by-Step Guidance: The video walks you through each step with clear explanations, making it easy to understand and implement.
- Downloadable Workbook Template: Access a ready-to-use Excel workbook template to practice and implement the techniques learned.

This video covers a few topics:
1. How to find multiple matches - (basically an INDEX MATCH that finds all matches instead of the first one only)
2. How to fix table column referencing (absolute column referencing in tables)
3. How to use OFFSET to restrict the dependent drop-down list to non-empty members only (exclude empty cells)

We're going to learn all this, while creating a dependent drop-down list based on a messy random tabular data set.

Links to related videos:
Part 1 - Get the Unique drop-down list: https://youtu.be/7fYlWeMQ6L8
Index Match basics: https://youtu.be/F264FpBDX28
Offset: https://youtu.be/RPTQjbk2qy4

This video from Kevin Lehrbass summarizes all the different techniques you can use to get a unique drop down list (for Part 1 of the video): https://youtu.be/BFojgCsKNjw

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