Not possible, you would need as many cells as there are projects done
by "A. Mole"

--


Regards,


Peo Sjoblom

"Andy" wrote in message
...
Hi,
I'm trying to add a column on a new worksheet that looks up from data from
an existing worksheet, which looks like this:
Company Projects
A. Mole b10
A. Mole b15
A. Mole b13
J. Beam b12
E. Potter b11
E. Potter b14

I would like to be able to find ALL the projects done by "A. Mole" and
return the data into ONE cell.
And so on so that the new sheet would look like this:
Company Project
A. Mole b10, b15, b13
J. Beam b12
E. P otter b11, b14

If anybody can help i'd be extremely grateful.
Cheers Andy