Return Multiple Match Results in Excel (2 methods)

Save
2 years ago
6
return multiple match values with index vlookup multiple matches vlookup aggregate with small Aggregate formula Index and match excel lookup textjoin formula XelplusVis excel CSE excel array formula

Aug 30, 2018 Excel Advanced Formulas & Features
‍‍‍‍
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/

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:

★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

00:00 How to Find Multiple Match Results in Excel
01:10 How to Use INDEX & AGGREGATE to Find Multiple Matches in Excel
11:12 How to Use TEXTJOIN to Find Multiple Matches in Excel
13:36 Wrap Up

- 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.

🡻 Download the workbook here: https://www.xelplus.com/return-multiple-match-values-in-excel/

★ Links to related videos: ★
VLOOKUP basics: https://youtu.be/E7gQ-PgYkMc
INDEX MATCH basics: https://youtu.be/F264FpBDX28
Get Unique List: https://youtu.be/7fYlWeMQ6L8
TEXTJOIN: https://youtu.be/TMZEUlFGp1U

★ My Online Excel Courses ► https://www.xelplus.com/courses/

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

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

GEAR I use: https://www.xelplus.com/resources/#gear

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

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/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 #LeilaGharani

Loading comments...