View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default 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