Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)

11 months ago
9
TabularMessyList dependent drop down list find many matches Excel match multiple results INDEX formula exlude empty cells in dropdown excel table absolute reference column Vlookup many results AGGREGATE function Restrict drop-down to non empty Excel table references

March 15, 2018 Excel Dashboards & Reports
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.

🡻 Download the workbook here 🡻
http://www.xelplus.com/find-multiple-matches-in-excel-dependent-drop-down-list/

★★ Links to related videos: ★★
Part 1 - Get the Unique drop-down list: https://rumble.com/v2tuqys
Index Match basics: https://rumble.com/v2skkko
Offset: https://rumble.com/v2skd7u

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 ★

Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

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!

#MsExcel

Loading comments...