Quote Originally Posted by jeffwtn View Post
Hi Rick ,

I have tried your solution , at first it is all working well, but when I open it again there are some errors

=LookUpConcat(A2,$A$2:$A$20,$C$2:$C$20,", ")

A2 is the lookup where as it came out as #VALUE!
and then the final result came out as NAME?
Pictures 1.jpgPictures 2.jpgNAME?

anyway of fixing this ?
Many thanks
Assuming there is no sensitive data... can you post a copy of the workbook so I can debug the problem with a live sheet? If there is sensitive data, can you delete it without affecting the problem you are reporting and then post of copy of that modified workbook instead?