Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)

Finding an Excel solution to get MULTIPLE matches for a lookup value is often causing major headaches. The go-to VLOOKUP formula does not work here because it just returns the first match!
What if you wanted to use VLOOKUP but return ALL matches? You can do that now, with the new FILTER function available in Microsoft 365. But what if you don't have Excel 365? Is there an easy function that can return multiple match results?

In addition, I'll show you other options you can apply depending on your version of Excel:
- If you have Microsoft 365 you can take advantage of the new FILTER function
- In Excel 2019 you can use the TEXTJOIN function
- For Excel 2010 and higher you can use the AGGREGATE function

This way you have the COMPLETE guide for any situation on how to find multiple matches in your Excel data set.

00:00 How to Get Multiple Matches in Excel
01:17 Easy Solution For All Excel Versions
11:31 Solution with TEXTJOIN & AGGREGATE
11:50 Easiest Solution with FILTER
12:19 Wrap Up

🚩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

[kevorkvartabedian]

This Girl is Amazing, your channel helps me to be pro in Excel.

[FazlulKarimChowdhury]

Leila, you are the sweetest instructor I follow on the internet! Just imagine, how many excel-ninjas you have been created!!! Thank you.

[dog]

Fantastic. I many read web pages & watched videos many examples of MULTIPLE matches, but this is the only one that I could get to work. Very well explained. Thank you.

[Michael-sywr]

It's just amazing. There's no other channel I go first when I'm looking for a clever solution for an Excel problem. Keep it up!

[thomasschmidt]

I am currently forced to use Excel 2019, and this video came in so handy, like many of your videos. Thank you so much!

[robertakwasiadjei]

Thanks a Lot Leila, Indeed you're great. Stay Blessed

[nobodynobody]

You are the best Leila, you went beyond and provided alternatives to people.

[bangarur]

I always refer your videos while I prepare Dashboards.
Thanks for your videos.

[OasisExcelMaster]

You definitely know your stuff. I enjoy rescuing myself here. I use almost everything there's in excel in my line of work.

[sachinrv]

Amazing video Leila. Frankly it is too much for many including me. One has to watch your videos on Index & Match and Offset before proceeding to this video.

[eibikakon]

Greetings and blessings, I would like to tell you personally that I have actually become professional in Excel thank you so much for the videos

[ehabmahmoud]

I applied it to my cash/bank control sheet to generate vendors' statement of account and it worked perfectly fine, BIG thanks you Leila.

[ONNAMUKBANGASMR]

Thank you for enlightening me Leila with your cool Excel Tricks!

[LinneaLindstrom]

I love the new 365! Have been a huge help already for me in my work

[dennisd]

Thank you for showing so many different method to accomplish the goal.

[mcd]

Seven differ approaches for finding multiple matches explained in less than 13 minutes. Truly amazing.

Can't wait till the day all of us can share in your excitement for the utopia that is the Filter function.

[sisirakumara]

Thanks and respect TEACHER, Your explanation is great, Excel easier than before

[sgtpmbf]

like the logic way you are teaching to us, easy to understand and put into practice

[siddarthsaraf]

hello, I am from India..your lessons are helpful, thanks .

[ThierryLalinne]

Brilliant! Thank you Leila for sharing all those variations with us. I learn a lot from you.