單格多人 找出班級 (14861)

C2:F5{=INDEX($J:$J,SMALL(IF(MMULT(1-ISERR(0/(FIND(TRIM(MID(SUBSTITUTE($B2,"；",REPT(" ",99)),COLUMN($A:$Z)*99-98,99)),"A"&$I$2:$I$5)>1)),ROW(1:26)^0),ROW($2:$5),99),COLUMN(A1)))&""