vlookup and concatenate multiple occurences
 

Hello all,
I am trying to do a vlookup with multiple occurences of the same
value, then return the next column over concatenated with all of the
other occurences. For instance. If I had A1 = 1 A2 =1 and A3 = 2.
If B1 = Dog, B2 = cat, and B3 = gopher. If I were looking up 1 in
column A there are 2 occurences so i woudl want it to return Dog,
Cat. Can this be done, or do I need a for next loop?
Jay