Lookup value and show all corresponding values in one cell

[charleymax]

Hi all,

Many apologies if this is easy but I seem to have struggled with it for hrs now...

I have a data set where I want to have a column that looks up a document number and shows me in one cell all the project numbers it is linked to...
If the document only shows up once for one project I want it to state None...

So A1 looks up C1's value i.e. Doc 1234 and sees that through all of Col B it is listed as involved in the MSG, PPP and ZyD projects... So in A it would return MSG, PPP,ZyD...

Want it to look like this

 

[charleymax]

yayyyyyy!

Thanks Mick... Tht's exactly what I wanted.