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

YOUR LINK HERE:

http://youtube.com/watch?v=5cBUIa31AiA

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou... • 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-ma... • 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: • Return Multiple Match Results in Exce... ). 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: • Return Multiple Match Results in Exce... • FILTER: • How to Use the Excel FILTER Function ... • TEXTJOIN AGGREGATE: • Return Multiple Match Results in Exce... • ➡️ Join this channel to get access to perks: / @leilagharani • 👕☕ 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: / lgharani • LinkedIn: / 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

#############################

New on site