Question

excel A1里包含某个值，B1返回一个值。

如果A1里包含北京，B1返回张三，如果A1里包含上海，B1返回李四，如果A1里包含广州，B1返回麻子。谢谢大神





Answer 1

A2输入以下公式

=IF(COUNTIF(A1,"*北京*"),"张三,","")&IF(COUNTIF(A1,"*上海*"),"李四,","")&IF(COUNTIF(A1,"*广州*"),"王五,","")

 

详见附图

Answer 2

=IF(ISNUMBER(FIND("北京",A1)),"张三",IF(ISNUMBER(FIND("上海",A1)),"李四",IF(ISNUMBER(FIND("广州",A1)),"麻子","")))
如果太多，建立对应表
用VLOOKUP函数

追问

谢谢啦，已解决