WATCH ON YOUTUBE NOW:
Return Multiple Match Results in Excel (2 methods)
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.