四個字符串 一公式分別取出 (13261)

F3:F8{=INDEX($A:$A,SMALL(IF(($C$2:$C$31=OFFSET(F$1,LOOKUP(1,0/(RIGHT(F$2:F2,2)="紧急"),ROW($1:1)),))*($B$2:$B$31=$J$2),ROW($2:$31),99),ROW(A1)-LOOKUP(1,0/(RIGHT(F$2:F2,2)="紧急"),ROW($1:1))+1))&""

F3:F8複製到各區