Hi All,
I've been reviewing many entries in the forum to help me complete a task
I signed up for. Although I have learn much from the many responses I still
haven't solved my specific problem. I'm sure I could if time permitted but
now I'm under the gun to complete. I have a long list of names of
volunteers and a long list of activities the voluteers can signup for. Want
I want to do is create a listing of the voluteers and what they volunteered
for without having to re-type all the activities for each voluteer. Here
are the table layouts:

Table A - each volunteer identified by number in Col A.
A B C D
Name Activities
1 Volunteer 1
2 Volunteer 2
3 Volunteer 3
4 Volunteer 4
5 Volunteer 5

Table B - A list of activities with index numbers of all the volunteers to
the cells on the right.
A B C D E F G
Activities
Animal Science 1
Archaeology 3 5
Archery 2 1 4 5 3
Architecture 5 3 4
Art 2 3 1

What I would like to do for each voluteer is search the activities in Table
B for all the activities assigned and input the list of activities (separated
by ",") in column "b" next to the volunteers name in Table A.