以C欄數字 取對應D欄 (12055)

D2:G8{=INDEX($B:$B,SMALL(IF($C$2:$C$16=COLUMN(A1),ROW($2:$16),99),ROW(A1)))&""

另解{=IFERROR(INDEX($B:$B,MATCH(1,(COUNTIF(D$1:D1,$B$2:$B$16)=0)*($C$2:$C$16=COLUMN(A1)),)+1),"")