I want to creat a list from data pulled from a table. If I use VLOOKUP it will pull the first instance of the matching data, but I need to create a list whenever the lookup value is met.

Column1 Column2
Joe Red
Sally Blue
Frank Green
Joe Green
Bill Blue
Joe Orange

If my lookup value = Joe (C7), I want a list of Red, Green, and Orange.

Currently I'm using: =VLOOKUP($C$7,Table1,2,FALSE) which returns only Red.

I've read thru several postings and I've seen some array and index formulas, but I can't quite get those to work. Any help is appreciated! Thanks.