Copy colors / names from Sheet2 to Sheet1

[Berna11]

Hello, I need your help to copy the colors / names from Sheet2 to sheets1.
Copy only those colors that have the code in column E N11, and in column C = CSD.
If the color is repeated in column A and in column E = N11 but the code in column C is a code other than CSD may not be copied.
I am attaching the file where you understand better what I would get.
Thanks in advance.
Copia colore.xlsx

[Fotis1991]

IN Sheet2!B2, put this and copy down(you can hide this column)

=IF(E2="N11";SUMPRODUCT(($A$2:$A$11=A2)*($C$2:$C$11<>"CSD"));"")

Then in Sheet1! use this ARRAY formula

=IFERROR(INDEX(Foglio2!$A$2:$A$11;SMALL(IF(Foglio2!$B$2:$B$11=0;ROW(Foglio2!$A$2:$A$11)-1);ROW(Foglio2!A1)));"")

[Berna11]

hank you very much Fotis1991 problem solved