Lookup & return multiple values in one cell, separated by comma

Hello,

I have been trying to find a function that performs like vlookup or index-match but it returns multiple matches in a comma separated list. I have come to the tentative conclusion that this is only possible with VBA. I have found a few solutions, however they seem require Microsoft 365 (which I don't have) or Office 2019 (I have 2016).

Given these constraints, does anyone have a solution?


Thank you!

UDF
Use in cell like
=VLookUps(A1,$C$1:$E$21,2,",")
where
A1 = Search value
$C$1:$E$21 = LookUp Range
2 = Column reference
"," = Join string

Please Login or Register  to view this content.

Thank you, but for some reason even when I past this code into VB, excel still does not recognize the function. Am I doing something wrong?

Which code module did you use?
The code needs to be placed in a standard cide module.

Oh that was the problem. It worked! Thank you