Return Multiple Match Results in Excel (2 methods)

Return Multiple Match Results in Excel (2 methods)

 

 

Quickly learn how to lookup one value in Excel and return multiple matches. VLOOKUP and INDEX & MATCH formulas always return the first match they find inside a data table. What if you wanted 

 

to return multiple matches? I'll show you two different methods:

Method 1: Uses INDEX & AGGREGATE formulas. This doesn't require CSE (control shift enter) 

 Method 2: Uses the relatively new TEXTJOIN formula (available in Excel Office 365, Excel 2019)  

Related Topics:

• Lock Cells and Protect Excel Worksheet - EVEN by Cell
• Change CASE of text in Excel (3 ways including NO Formulas) 
• Excel's Find and Replace (surprising features)
• All about Excel Comments ( Notes ) in 8 Minutes! Shortcut Keys, Customize Background and More