I need to do a VLookUp and return multiple results into 1 cell. For example, I have the following information. (assume the number are stock codes or something)

Red 1234
Red 2345
Red 4321
Red 5432
Blue 7589
Blue 8598
Blue 7858
Green 4659
Green 9587
Green 6859

The above would be on one sheet, then on another sheet, in Column A, I'd have Red, Blue & Green in their own cells. Then in Column B, I would do a VLookUp using the adjacent cell as it's "target" and would want to result all possible results, not just the first

IE, Cell A1 would say Red, and I'd want cell B1 to return "1234, 2345, 4321, 5432" as its value

Is this possible?

TIA,

Mat