Premium Only Content

Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)
28 May 2020 Excel Lookup Formulas
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 this tutorial I'll show you a simple(er) approach that solves this challenge in 2 simple steps. It works in all versions of Excel and is quite easy to remember (at least easier than my original Aggregate version here: https://youtu.be/fDB1Ktyhp3Y). Many thanks to Bob Umlas for sending me this solution!
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
⯆ DOWNLOAD the workbook here (scroll to the bottom of the post): https://www.xelplus.com/excel-multiple-match-results-complete
LINK to original video: https://youtu.be/fDB1Ktyhp3Y
FILTER: https://youtu.be/Eehk6PC0oGs
TEXTJOIN & AGGREGATE: https://youtu.be/fDB1Ktyhp3Y
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
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 #Excel #LeilaGharani
-
LIVE
Barry Cunningham
55 minutes agoPRESIDENT TRUMP MAKES SPEECH ABOUT AI
993 watching -
LIVE
Dr. Drew
4 hours agoBenny Johnson & Mama June: America & Families In Crisis w/ Pumpkin & Jessica (The Double Feature Nobody Expected) – Ask Dr. Drew
730 watching -
13:40
Preston Stewart
6 hours agoMajor Protests Erupt in Ukraine
40 -
LIVE
LFA TV
19 hours agoLFA TV ALL DAY STREAM - WEDNESDAY 7/23/25
1,561 watching -
19:16
Clownfish TV
12 hours agoColbert Calls Himself a MARTYR and Tells the President to GO F HIMSELF!
1.1K16 -
1:14:39
vivafrei
3 hours agoTrump Accuses Obama of TREASON! Macron SUES Candace Owens? Canada is Run By the INMATES! & MORE
102K36 -
Pop Culture Crisis
2 hours agoVanessa Kirby ALL OVER Pedro Pascal at FANTASTIC FOUR, Ozzy Reincarnated as AQUAMAN? | Ep. 883
20.3K -
1:29:31
The Quartering
3 hours agoToday's Breaking News! Kohberger ROASTED In Court, Will Trump Prosecute Obama?
112K19 -
LIVE
The HotSeat
1 hour agoWhy Christians Should Lead With Grace, Not Condemnation | Where's JOY?
567 watching -
LIVE
The Nunn Report - w/ Dan Nunn
1 hour ago[Ep 712] Art of the Deal on Steroids – Trump Trade Wins! | Fed Reserve Building Fraud & Lies
162 watching