vlookup returns multiple value

How can I use VLOOKUP (or another way) to return multiple values. For example, in the list:

A 1
B 3
C 4
B 2
B 1

I want to search for the value B which corresponds to values 3, 2 and 1.

I would like to output this into seperate horizontal cells in a format like:
A 1
B 3 2 1
c 4

Is this possible? If so, how would i go about doing this?

You should see Dean's response to my very similar question. It looks like it may work for you as well. Here's a link to the thread.

http://www.excelforum.com/showthread.php?t=648435

I hope you have better luck understanding the formula than I did. I guess I've never seen an "array" formula before.

Good luck.

Hutch