I have two worksheets named "Profit data" and "Labor". The Profit data sheet
includes amongst other things, the following:

Col A
Job #
Row 2 1185
1186
1204
1207
1214
to row 48

The "Labor" sheet has Employee Names and Jobs they worked on. E.G.

Col C Col D etc all the way to Col CH
Row 3 Brian Bill
Row 4 1202 1185
Row 5 1185 1214
etc
to Row 81

As an example In the "Profit data" sheet in Cell Z2 I want to create a
function that takes job 1885 and looks in the labor sheet for 1885 and then
returns the person's name that appears in Row 3, separated by a comma if more
than one person worked on the job. E.G. For Job 1885 the function needs to
return Brian,Bill

What is the best way to do this? I thought of using a lookup table but was
not sure how to return multiple names into the cell which are separated by a
comma.

Thanks.