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

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

 

 

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. 

Related Topics:

• Get ALL External Links with This SIMPLE Excel TRICK (as NEVER seen before!) 
• VBA to BROWSE and COPY Data from SELECTED File in Excel 
• Excel List Box to Display and Print Multiple Sheets as ONE Print Job with VBA 
• Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)