How to find multiple matching results in Excel (for all excel versions).
🚀Get FREE Excel chart templates from Hubspot: https://clickhubspot.com/rn5i
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/ntyppee58s
In this video tutorial you'll learn how to find multiple matching results in Excel. When using the VLOOKUP or the XLOOKUP functions, you might have noticed it only returns one matching value, even if there are multiple matches. This is confusing and can often lead to mistakes. So the first alternative is to use the Filter Tool. This is very simple. However, it doesn't let you see all the data, and other formulas like the SUM don't work correctly when the Filter is applied. A better alternative I show you is the FILTER function, which shows you the original dataset, and ALL the matching values on the side. You can even customize further with the IF Empty option, and only return specific columns too. As the FILTER is not available for all Excel versions, I also show you another alternative that combines the IF function and the TEXTJOIN function.
LEARN:
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Problem with XLOOKUP & VLOOKUP
1:25 - Basic Solution
2:28 - Better Solution
4:11 - With If Empty
5:16 - Specific Column
5:50 - FILTER Alternative