Concatenate the lookup values from all occurences
Nevermind. I was over thinking it. below works.
Function Concpos(Item As Range, Items As Range)
Dim c As Range
For Each c In Items
If c = Item Then
Dim Concat As String
Concat = c.Offset(0, 1).Value & ", "
Concpos = Concpos & Concat
End If
Next
End Function
Thanks Jay
|