指定工号 對應数据提取 (10094)

E2{=INDEX(B:B,SMALL(IF(COUNTIF(D:D,A$2:A$16),ROW($2:$16),99),ROW(A1)))&""

F2{=IFERROR(INDEX(B:B,RIGHT(SMALL(IFERROR(MATCH(A$2:A$16,D:D,)/1%+ROW($2:$16),""),ROW(A1)),2)),"")