This video displays how to create a VLOOKUP Function that pulls back "multiple matches" based on a search value in Excel. This is done through the use of a "helper column" in the lookup array that performs a "running" COUNTIF on duplicate lookup values in the original lookup column. This results in a column of "unique lookup values" to search on. The end of the video shows how to dynamically create unique lookup values within the VLOOKUP Function itself to pull back all the unique values for a given search item.

To get a copy of this workbook to follow along click on the link below and look for the same title as this video:
theexcelcave.weebly.com/vlookup-series.html

Learn more about Excel Functions & Features with this book at Amazon:
amzn.to/3xtLmXp

Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.

#ExcelVlookupMultipleMatches
#VlookupReturnMultipleMatchesInExcel
#ExcelTipsAndTricks

• Excel VLookup to Return Multiple Matches ( Download)
• VLOOKUP All Matches with this Crazy Simple Trick ( Download)
• Return Multiple Match Results in Excel (2 methods) ( Download)
• Unlock the Power of Vlookup : Multiple Values, Criteria & Columns - Excel Magic! #shorts #vlookup ( Download)
• Vlookup Trick for multiple columns ( Download)
• Lookup & Return Multiple Values in One Cell in Excel (Easy Formula) ( Download)
• MS Excel LOOKUP Formula: Return Multiple Values ( Download)
• Awesome Excel Trick 🤯 Return Multiple Matches in VLOOKUP!📊 #shorts ( Download)
• How to use VLOOKUP & XLOOKUP in excel multiple sheets ( Download)
• VLOOKUP multiple matches in Excel - Trick ( Download)
• VLOOKUP Multiple Matches in Excel | Using VLOOKUP When You Have Multiple Matches | Excel Tutorial ( Download)
• Excel VLookup Return Multiple Matches on Multiple Lookup Values ( Download)
• How to make Vlookup function Returns Multiple Matches, Different Results ( Download)
• #shorts | VLOOKUP with MATCH in Excel ( Download)
• Vlookup with Multiple Columns in Excel 🎯Vlookup Multiple Values-Vlookup Multiple Criteria #excel ( Download)