Create a Vlooup Function To Extract All The Associated Values

Apr 5, 2019 | Excel, VBA | 2 comments

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 multiple matched values.

VBA Script

2 Comments

  1. Shyam Sebastian
    Shyam Sebastian on 2021-09-09 at 6:42 PM

    Can we have the extraction of data to multiple cells instead of coma separation to single cell.

    Reply
  2. Sininen
    Sininen on 2023-03-26 at 2:13 PM

    Similar request as previews, is it possible to get result in each line separated.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *