必須與任一字樣 二條件 (14922)

C2{=INDEX(A:A,SMALL(IF(ISNUMBER(FIND("供电局",A$2:A$20))*MMULT(1-ISERR(FIND({"重固","青浦区"},A$2:A$20)),{1;1}),ROW($2:$20),99),ROW(A1)))&""

另解{=INDEX(A:A,SMALL(IF(MMULT(1-ISERR(FIND({"供电局","重固","青浦区"},A$2:A$20)),{2;1;1})>2,ROW($2:$20),99),ROW(A1)))&""