EXCEL IF 函数 模糊查询
A列都是产品名,比如衬衫,长袖衬衫,短袖衬衫,短裙,长裙 搜索A列的产品名,凡是含有“衬衫”的一律在B列对应行输出“衬衫”,凡是含有“裙”字的一律输出“裙子”在B列对应行,请教一下怎么写函数,本来用IF函数: =IF($A8="衬衫","衬衫",IF($A8="裙","裙...
输入以下公式
=IF(COUNTIF(A8,"*衬衫*")>0,"衬衫",IF(COUNTIF(A8,"*裙*")>0,"裙子",IF(COUNTIF(A8,"*外套*")>0,"外套","其他服装")))
=IF(H2="成交词","A")
-------------------------------------------------------
=IF(COUNTIF(B2,"*费用*")>0,"成交词",
IF(COUNTIF(B2,"*多少钱*")>0,"成交词",
IF(COUNTIF(B2,"*价格*")>0,"成交词",
IF(COUNTIF(B2,"*怎*")>0,"询问词",
IF(COUNTIF(B2,"*仪器*")>0,"询问词",
IF(COUNTIF(B2,"*去皱*")>0,"询问词",
IF(COUNTIF(B2,"*副作用*")>0,"询问词",
IF(COUNTIF(B2,"*原理*")>0,"询问词",
IF(COUNTIF(B2,"*超声刀*")>0,"询问词",
IF(COUNTIF(B2,"*除皱*")>0,"询问词",
IF(COUNTIF(B2,"*方法*")>0,"询问词",
IF(COUNTIF(B2,"*射频*")>0,"询问词",
IF(COUNTIF(B2,"*窍门*")>0,"其它",
IF(COUNTIF(B2,"*技巧*")>0,"其它",
IF(COUNTIF(B2,"*妙招*")>0,"其它","其它")))
----------------------------------------------------------------
=IF(COUNTIF(H2,"*其它*")>0,"C",
IF(COUNTIF(H2,"*成交词*")>0,"A",
IF(COUNTIF(H2,"*询问词*")>0,"B",
"D")))
-------------------------------------------------------------------
IF(COUNTIF(H2,"*超声刀*")>0,"询问词",
最新文章
- 新华龙电子推出最新网络开发板(W5100&;W5500方案)
- nginx相关
- RichTextBox文字处理控件属性介绍
- ubuntu安装spark on yarn
- FileUpload之FileItem
- NHibernate's inverse - what does it really mean?
- SHA-2 Certificate Signing Request
- 管理IPv4网络连接
- 20141113--SQL 事务
- LINUX 内核与 systemtap +GO 专家博客 一个[ 系统软件工程师] 的随手涂鸦
- PHP5.4的变化关注---What has changed in PHP 5.4.x(转)
- bash:ifconfig command not found for contos7.0
- Struts2第九篇【OGNL、valueStack详解】
- Docker自制CentOS镜像
- hdu 1002 A + B Problem II【大数加法】
- SQL SERVER 2016研究三
- ChIP-seq实战 | 染色质免疫共沉淀技术 | ATAC-seq | 染色质开放性测序技术
- 【转】CSS3 Box-sizing
- 【转】ubuntu apt-get update 失败解决
- apache做转发