提取关键字并输出指定内容

liu213499 · 发表于 2024-3-15 11:44

请教各位老师，如图，B列为模拟后要输出的内容，最后两位数字24/23/27不会出现重复

无关岁月 · 发表于 2024-3-15 11:56

=IF(MAX(1-ISERR(SEARCH("W????"&{23,24,27},A1))),"PCN",IF(LEFT(A1)="W","自研",IF(LEFT(A1,2)="YW","研发","")))

复制代码

世界客都 · 发表于 2024-3-15 11:56

=IF(LEFT(A1,2)="YW","研发",IF(AND(RIGHT(A1,2)-{23,24,27}),"自研","PCN"))

boyuanoffice · 发表于 2024-3-15 12:26

=IFS(LEFT(A1,2)="YW","研发",OR(LEFT(A1)&RIGHT(A1,2)="W"&{24,23,27}),"PCN",LEFT(A1)="W","自研",TRUE,"数据异常")

复制代码

Excel地板砖 · 发表于 2024-3-15 12:45

=IF(LEFT(A1,2)="yw","研发",IF((LEFT(A1)="w")*MAX(N(RIGHT(A1,2)={"23","24","27"})),"PCN","自研"))

复制代码

hxj119 · 发表于 2024-3-15 13:07

=IF(LEFT(A1,2)="YW","研发",IF(AND(LEFT(A1,1)="W",OR(--RIGHT(A2,2)={23,24,27})),"PCN","自研"))

我的城市你来过 · 发表于 2024-3-15 16:04

=IFNA(IFS(MMULT(--ISNUMBER(FIND({23,24,27},$A$1:$A$11)*(LEFT($A$1:$A$11,1)="W")),ROW($A$1:$A$3)^0)=1,"PCN",LEFT($A$1:$A$11,2)="YW","研发"),"自研")

swl4561255 · 发表于 2024-3-15 16:15

=IF(LEFT(A1,1)="W",IF(OR(RIGHT(A1,2)={"23","24","27"}),"PNC","自研"),IF(LEFT(A1,1)="Y","研发",""))

复制代码

HAOQ · 发表于 2024-3-16 15:40

=IF(LEFT(A1,2)="YW","研发",IF(IFERROR(MATCH(--RIGHT(A1,2),{24,23,27},0),0),"PCN","自研"))

		自动登录	找回密码
密码			免费注册

[已解决] 提取关键字并输出指定内容