Excel VLookup to Return Multiple Matches

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.w...
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