LookUp Value and Concatenate All Found Results

[Rick Rothstein]

I saved my workbook as macro enabled and saved your UDF code as a module. However when I enter the formula into my table I get the following error: Compile Error. Unexpected end function.

Is there a way to trouble shoot this?

Capture.jpg

It is hard to see that small picture, but if what is displayed in the picture is all of the code you copied, then you did not manage to copy all of the code there is.

[rwoodsum]

It is hard to see that small picture, but if what is displayed in the picture is all of the code you copied, then you did not manage to copy all of the code there is.

Oh gosh I didn't even see that the original code has a scroll bar