多條件不重复 提取 (10484)

G2:J5{=IFERROR(INDEX(A:A,SMALL(IF(IFERROR(MATCH(1&$C$2:$C$14&1,(MMULT(N({"重要","一般"}=$B$2:$B$14),{1;1})>0)*1&$C$2:$C$14&($D$2:$D$14>10000)*1,),99)=ROW($1:$13),ROW($2:$14)),ROW(A1))),"")