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:50:27
vivafrei
14 hours agoEp. 210: Stormy Gags on Lies! Hunter Not Immune! AstraZeneca Pulled & MORE! Viva & Barnes
116K184 -
1:50:54
Jewels Jones Live
2 days agoUNDERSTANDING NEXTGEN MARXISM | A Political Rendezvous - Ep. 76
53.4K40 -
8:22:56
Akademiks
1 day agoAll Will Be Revealed! Drake vs Kendrick vs The Riddler. Who Lied, Who Snaked, Mole Finally Revealed!
145K97 -
1:08:38
Russell Brand
2 days ago“You’re Going To Get KILLED!” Mike Benz EXPOSES CIA Secrets Like NEVER Before - Stay Free #363
375K782 -
1:35:13
Roseanne Barr
2 days ago $74.67 earnedKeep My Name Out Yo M*Therf*Cking Mouth! | The Roseanne Barr Podcast #47
182K418 -
1:19:00
Steven Crowder
3 days agoBradley Martyn and Vitaly's Hollywood Pedo Bust Goes Wrong! Guests: Alex Rosen | Vivek Ramaswamy
675K1.1K -
53:40
The Osbournes
5 days ago $1.11 earnedWould You Eat a Monkey? Osbourne's Wildest Meals
83.9K16 -
1:19:01
Steve-O's Wild Ride! Podcast
3 days agoMike The Situation Went To Prison & Owes Millions, But Remains Grateful - Wild Ride #213
91.4K13 -
9:45
RealReaper
1 day ago $7.17 earnedVelma is The Worst Show of 2024: Part 1
89.6K107 -
23:13
InfiniteWaters(DivingDeep)
1 day agoBiggest Solar Storm in 20 Years Could Cripple Internet, Phones, And Power Grids (Prepare Now!) 👁️
105K129