取對應值 依出現次序 (11673)

C2{=INDEX(H:H,SMALL(IF(G$2:G$11=B2,ROW($2:$11)),COUNTIF(B$2:B2,B2)))

D2{=VLOOKUP(B2&COUNTIF(B$2:B2,B2),IF({1,0},G$2:G$11&COUNTIF(OFFSET(G$2,,,ROW($1:$10)),G$2:G$11),H$2:H$11),2,)