比赛次別 取成绩 (11195)

G2{=IFERROR(VLOOKUP(E2,OFFSET(A$1:B$1,MATCH(LOOKUP(9,FIND("比赛",E$2:E2),E$2:E2),A:A,)-1,,SUM(N(LOOKUP(9,FIND("比赛",E$2:E2),E$2:E2)=LOOKUP(ROW($2:$14),ROW($2:$14)/ISNUMBER(FIND("比赛",A$2:A$14)),A$2:A$14)))),2,),"無此人")