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
Kimberly Guilfoyle
2 hours agoRussia Hoax Reality Check, Live! | Ep240
453 watching -
1:07:35
vivafrei
2 hours agoWall Street Journal DOUBLING DOWN on Epstein! Lawyer in Canada DEBANKED! AND MORE!
83.9K17 -
4:42:20
Donut Operator
5 hours agoI'M BACK/ CRIME/ GAMEBOY CAMERA CHAD
88.6K4 -
9:51
Warren Smith - Secret Scholar Society
5 days agoThe Moment Tim Pool Discovered Why Andrew Wilson is so Unstoppable
11.3K23 -
28:23
Film Threat
4 hours agoLIVE FROM SAN DIEGO COMIC-CON! (Thursday) | Film Threat Live
364 -
1:40:00
The Quartering
2 hours agoEpstein Burnout, Hulk Hogan Dies, South Park Flops & Much More
113K28 -
10:05
Michael Button
6 hours ago $0.10 earnedGroundbreaking Discovery at Stonehenge Rewrites History
9.76K6 -
LIVE
RalliedLIVE
3 hours ago $2.48 earnedSPECIALIST ADDICTED MAN WINS WARZONE SOLOS
211 watching -
1:11:41
Sean Unpaved
4 hours agoBat Flips to Boardrooms: Jets QB Crossroads, Presidential Visits, & RedZone's TV Takeover
45.9K -
45:32
SportsPicks
4 hours agoCrick's Corner: Episode 51
4.32K