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

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 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? ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/multiple-matches-complete-file 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 LINK to original video: https://youtu.be/fDB1Ktyhp3Y FILTER: https://youtu.be/Eehk6PC0oGs TEXTJOIN & AGGREGATE: https://youtu.be/fDB1Ktyhp3Y ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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