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-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: • Excel FILTER Function - Lookup to Ret...
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
Смотрите видео Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Leila Gharani 28 Май 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 368,51 раз и оно понравилось 4.6 тысяч людям.