在B1输入或复制粘贴下列公式之一=IF(ISNUMBER(FIND("明慧生物",A1)),"宝骏",IF(ISNUMBER(FIND("公厕",A1)),"柳南仓库","未知"))=IF(COUNT(FIND("明慧生物",A1)),"宝骏",IF(COUNT(FIND("公厕",A1)),"柳南仓库","未知"))下拉公式
