=IF(VLOOKUP("*"&H2&"*",I2,1,0)=I2,TRUE,FALSE)
 
百度笔记：https://jingyan.baidu.com/article/4b07be3c61513e48b280f345.html
 
|   |
|---|
|注意IF等式中不能使用通配符 但是countif支持通配符<br><br>  <br><br>=IF(COUNT(FIND("外",A1)),B1,"")<br><br>  <br><br>或  <br>=IF(COUNTIF(A1,"*外*"),B1,"")|

|   |   |
|---|---|
|案例|=IF(OR(COUNTIF(M52,"*满意*"),COUNTIF(N52,"*满意*")),"满意","不满意")|