Excel 2007 : Help with a lookup that will return multiple occurrences

Hi,
I'm trying to figure out how to do a lookup that will return multiple occurrences. I searched the forums and tried to manipulate a function that was used to answer someone else's question, but it isn't working properly. Attached is a sample of what I'm trying to do. There are 2 sheets List and Flags. I would like to lookup the Number (Column C on List) and return all the Codes (Column H on Flags) in cells k-whatever on the List sheet. Hopefully, that made sense. The formulas I have in List K2:R4 and Flags J2:J24 are the formulas I was trying to make work. If I can get those to work that would be fine or if there is a better way to do it that would be great too. Thanks in advance for any guidance you can provide.

In K2 enter: =COUNTIF(Flags!$B$2:$B$24,$C2) and copy down.. you can hide this column. It is a counter.

In L2: =IF(COLUMNS($A$1:A$1)>$K2,"",INDEX(Flags!$H$2:$H$24,SMALL(IF(Flags!$B$2:$B$24=$C2,ROW(Flags!$B$2:$B$24)-ROW(Flags!$B$2)+1),COLUMNS($A$1:A$1))))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down and across as far as needed.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save