Excel中两列字符串为一对多的包含关系, 一列中每行字符对应包含在另列...答:E2:=IFERROR(INDEX(A:A,SMALL(IF(COUNTIF($C$2:$C$1000,"*"&$A$2:$A$1000&"*")>=COLUMN($A:$Z),ROW($2:$1000)),ROW(A1))),"")&""ctrl+shift+回车 F2:=IF(E2<>"",IFERROR(INDEX($B:$B,SMALL(IF(ISNUMBER(SEARCH(E2,$C$2:$C$1000)),ROW($2:$1000)),COUNTIF(...