Search:

Hi Thanks,

I have retry to do it , still not joy. At first even .xlsx working fine but after a while it just does not work anymore
file attached. Thanks again



Jeff

Sample attached. Thanks for your help.

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...