=IF(ISNUMBER(FIND(C1,A1)),B1,"")或=IF(COUNT(FIND(C1,A1)),B1,"")或=IF(ISERROR(FIND(C1,A1)),"",B1)下拉填充
=IF(ISERROR(FIND(C1,A1)),B1,"")公式下拉!
