I cannot figure this one out. I have a column of text which corresponds to a column of numbers. Some of the numbers are the same. I need a formula which will list all of the text corresponding to the number I tell it to search for.

Example:

-------A-------B
1----Bob-----3
2----Sue-----8
3----Mike----4
4----Jim------3
5----Tom-----9
6----Pam----2
7-----Pat-----3

I need a formula which would provide me a result of "Bob, Jim, Pat" when I search for "3". Or even a combination of formulas which would give me
Bob
Jim
Pat
... and I could use the concatenate formula to put them into one field.

Please help!!!