IF function that searches one column and lists the results in a paragraph

Originally Posted by XOR LX

Ok, then, assuming that the table you give above is in the range A1:B6, and that the word for which you wish to return the matches (e.g. "Blue") is in D1, enter this array formula (important that you know how to enter this type of formula in Excel) in E1 and copy to the right until you start to get blanks for the results:

=IFERROR(INDEX($B$1:$B$6,SMALL(IF($A$1:$A$6=$D1,ROW($A$1:$A$6)-MIN(ROW($A$1:$A$6))+1),COLUMNS($A:A))),"")

Regards

Hmm, maybe I don't know how to enter array forumulas because I copy/pasted that into a workbook of exactly what I did in the post (not actual data) and it didn't work. Any suggestions?

Thanks