I am trying to lookup a value and return all of the assocuated information into one cell.
Each returned piece of data should be seperated by a comma.
I have gotten close to what I want, but it does not put every entry into the cell.
IF(COUNTIF(A:A,$C1)>=ROWS($1:1),INDEX(B:B,SMALL(IF(A:A=$C1,ROW($1:$999)),ROW())),"")
How do I concatenate each of the responses.
I have been using Ctrl+Shift+Enter to enter the cormulas
I am not looking for a VBA response.

As you can see belowI only get the value in cell B1 entered into cell D1.
I would like the answer to look like what is in cell D11

When copied into cell C2, I don't get the single response Thanks



MultipleCells.PNG

Test_Example.xlsx