Create a Vlooup Function To Extract All The Associated Values

Apr 5, 2019 | Excel, VBA

One of the limitations with Excel VLOOKUP function is that, when you have multiple matched values, the function will return the first matched record. In this tutorial, I will show you how to create a Used Defined Function (UDF) to perform VLOOKUP that can extract...