一對多取資料 用VLOOKUP (15194)

A2:A16=COUNTIF(B$2:B2,E$2)

F2=IFERROR(VLOOKUP(ROW(A1),A:C,3,),"")

G2無輔助{=IFERROR(VLOOKUP(ROW(A1),IF({1,0},COUNTIF(OFFSET(B$2,,,ROW($1:$15)),E$2),C$2:C$16),2,),"")

H2{=INDEX(C:C,SMALL(IF(B$2:B$16=E$2,ROW($2:$16),99),ROW(A1)))&""