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:

In this video, you'll discover:
▪️ Method 1: INDEX & AGGREGATE: Dive into a more complex approach that works on all Excel versions without requiring CSE (Control + Shift + Enter).
▪️ Method 2: TEXTJOIN Function: Explore a simpler, more straightforward method ideal for users with Excel 2016 and Office 365. This method utilizes CSE for optimal results.
▪️ Practical Examples: Learn through real-world scenarios, making it easier to apply these techniques to your own Excel projects.
▪️ Dynamic Data Sets: Understand how to work with various data sets, enhancing your flexibility and adaptability in Excel.

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

★ Links to related videos: ★

🚩Let’s connect on social:

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!

#excel

[mattsmit]

I started my first real job back in October of 2019 and I did not have a very comprehensive understanding of excel. As I took on more and more assignments and as my datasets kept growing, I realized I needed more than just long nested IF functions that got exponentially harder to maintain. Your videos have helped me branch out and use different formulas that I never would have known existed, as well as become faster at determining what formula suits my needs for a particular problem. Thanks a lot for these videos! Keep doing what you're doing and stay safe in this difficult time period!

[dannywoods]

If I'd still be in school and you were my teacher, you'd be my favourite one! I could just listen to you all day. And thanks for the lesson, it's excellent! Like!

[sandip_bettereveryday]

Very useful and informative video. Thank you. Power Query option also works great. After importing the range into Power Query, we can Group By using "Division". Thereafter adding a custom column using Table.Column function which will create a list of "Apps" column values. Then we can extract those values either through "Expand to new rows" or "Extract values" using a custom delimiter in the same row.

[starsbeyond]

Thank you so much for your explanation. This helps me a lot! Been searching for this past two days and I was stuck before I came here.

[pillionrider]

The second formula was easier to digest 🤣, while the first one was intimidating..I am a regular follower of your tutorials...this one seemed to be the most challenging...keep updating...

[paulbaker]

A masterclass. You have a great teaching style. Clear, concise, personable and your cadence is just right. I've watched many Excel tutorials and you're up there with the best

[brandonsouthern]

Amazing!! Thank you so much - nobody at my work could figure this out so now I look like a genius! :)

[praveenk]

I must admit, this is one of the best tutorial I have seen. I am sure I wouldn’t have done this without your tutorial. Day 1 - tried method 2, day 2 - went for method 1. Excellent tutorial.

[luapnomis]

Your presentation is the most complete and specific I've ever seen. The value of this is critical to our analysis for a software implementation. Keep up this good work, you're a star!

[mostafa]

Had to watch it twice to wrap my head around it. Excellent as usual.

[ImmaculateDrywall]

I've been looking through old and unhelpful videos to find exactly this solution, This video was extremally helpful and well explained.

[gracerogers]

This is one of those things where I didn't realize I needed it until I saw your video title... Great video, even 3 years later it still works! Thanks :)

[tylerroenicke]

You do such an excellent job giving a higher-level explanation while reviewing basic concepts. I really enjoy it.

[sriche]

Great Video! One thing about the textjoin option. You can use a character code for a delimiter. Like CHAR(10) then apply text wrapping and it will stack the results in one cell.

[alexuci]

I've been using method 1 for years, never understood how it works, just that it does. Now it makes sense, but I'll go with method 2 to make my life easier. Thank you so much my Excel goddess.

[daniel]

I had to watch this twice but you explained it very well. I am the Excel expert at every place I have worked but I am impressed by this. Good job.

[barttitulaerexcelbart]

Hello Leila. Great video. Excellent explained. John Walkenbach and mr Excel would be proud on your “mega formula”! I prefer the second solution but can you return the result in multiple cells without power query? For less advanced users I would however prefer another solution: add a help column with: =IF(cell=cell-tobe-found, row(), “ “). Then continue with your solution to use SMALL to collect all row numbers.

[N_O_R_R_I_E]

I need paracetamol after watching that lmao ! that was tough to keep up with !

[robertof.]

Thank you Leila. I used several tricks I learned on your course "Top Excel tips and formulas" in order to prepare an "automatic module for orders" for my job (I had to translate formulas in Italian too). I used expecially vlookup but this system has been the cherry on the cake of my module. My boss appreciated it.

[brieucballuais]

Leila ! I am a young entrepreneur, and using your Excel course made me switch from an expensive program (375USD / month) to NO-COST solutions on excel. You can't imagine how much I want to thank you for literally saving my company during this Covid Hard time. MERCI beaucoup !!!
Brieuc, from Thailand