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
-
1:01:52
Sean Unpaved
3 hours agoRyne Sandberg's Legacy, Madden's 99 Club, NIL's Locker Room Heat, & Wilkins' Kiss-and-Run
22.7K1 -
6:29
Clickbait Wasteland
17 hours ago $0.67 earnedCUOMO vs ZOHRAN: Who do New Yorkers Want as the Next Mayor?
15.8K11 -
22:10
IsaacButterfield
10 hours ago $0.99 earnedUnhinged White Woman Hates White People
18.7K24 -
1:04:05
Timcast
4 hours agoThe TAMURA Conspiracy, Theory Says Blackstone WAS The Target Over Israel, NOT NFL
166K105 -
2:15:27
Steven Crowder
6 hours agoNYC Shooting Exposes Massive Hypocrisy From Mamdani & the Left
382K381 -
1:36:20
The Mel K Show
4 hours agoMORNINGS WITH MEL K - An Engaged Fed Up Citizenry is Finally Moving the Needle Towards Accountability 7-29-25
44.9K21 -
1:17:30
Rebel News
3 hours agoByelection ballot drama, Ford flips on jobs for asylum seekers, Pipeline problems | Rebel Roundup
18.1K4 -
59:23
The Tom Renz Show
3 hours agoThe Manhattan Shooting, Vax Accountability, & Trump's Trade Deals In Crypto World
16.9K14 -
48:14
TheAlecLaceShow
3 hours agoGuest: George Papadopoulos | NYC Shooting In A Gun Free Zone | The Alec Lace Show
10.5K1 -
LIVE
LFA TV
18 hours agoLFA TV ALL DAY STREAM - TUESDAY 7/29/25
1,907 watching