VLOOKUP All Matches with this Crazy Simple Trick

Ever want to VLOOKUP but show multiple matching results? The standard Excel VLOOKUP formula has a limitation and it will only show the first matching result. But what if you need to see all matches in one place?

In this video, let me present you a simple formula to get all matches in a list format.

Sample file here - https://chandoo.org/wp/wp-content/upl...

More on VLOOKUP & Other functions (My Skillshare course):

Check out the Skillshare course on "Excel LOOKUPS for data analysis" and master these functions in just one hour. Here is your sign up link - https://skl.sh/3hbR49d

Learn more about FILTER function:

FILTER function basics and beyond -    • I don’t use filters in Excel anymore....  

Other ways to get multiple results with VLOOKUP:
   • VLOOKUP multiple matches in Excel - T...  

Excel VLOOKUP basics:    • How to use Excel VLOOKUP? Complete Be...  
XLOOKUP basics:    • STOP using INDEX MATCH in Excel, use ...  

Thank you for watching & reading. Have a beautiful day 😀🌞🌼

#VLOOKUP