Concatenate matched values and separate by comma

**scoffman** · 12-12-2012, 05:27 PM

Hi,

I have been searching through some of the threads on the forum and can't seem to find what I am looking for. I have a list of names on Sheet1 of the attachment. In the adjacent column, I need a formula that looks at the reference Name in column 1, searches for that in column 1 of Sheet2 and returns every corresponding value from column 2 of Sheet2 with them separated by commas.

Doing a countif is easy enough to identify how many times the Name shows up, but I need to know what the corresponding values are in the column next to that. Please see attachment, hopefully it will make more sense

Thank you!

ExcelExample.xlsx

**BB1972** · 12-12-2012, 06:06 PM

scoffman,

You can use a custom UDF which i came across at http://www.get-digital-help.com/2010...into-one-cell/

I've applied what's at that link to your sheet, but you should have a read through the link for an explanation which is far better than I can manage with the time I have available - no point in trying to reinvent the wheel

Hope this helps.