Hi,

I have a list of products.
Column A = Unique SKUS
Column B = Product Name
Column C= Product Family

ei:
Sku Name Family
123 Galileo Pendant Light Galileo
124 Galileo Wall Light Galileo
125 Galileo Floor Lamp Galileo
234 Unika Pendant Light Unika
431 Zara Pendant Light Zara
432 Zara Pendant 2 Light Zara

On a new column, I want to figure out a formula where I could get all the Sku of the same family separated by /

So the result would be:

Sku Name Family Related Sku
123 Galileo Pendant Light Galileo 124/125
124 Galileo Wall Light Galileo 123/125
125 Galileo Floor Lamp Galileo 124/123
234 Unika Pendant Light Unika N/A
431 Zara Pendant Light Zara 432
432 Zara Pendant 2 Light Zara 431


I have 6000+ products to sort out.
Can someone please help?
I tried:
=if(C1=C:C,A1,if(C1=C:C,A2,if(C1=C/C,A3,"N/A")))

But I know I am completely out of the mark.