YouTube: Return Multiple Match Results in Excel (2 methods) [Leila Gharani]

YouTube thumbnail image

WATCH ON YOUTUBE NOW:
Return Multiple Match Results in Excel (2 methods)
Leila Gharani

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) and it works on older Excel versions.

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

Pick the method you find easier to maintain.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×