成梦听雨 发表于 2021-12-14 10:18:00

求大神看看如何写公式?


B列:如果A列出现"BV",则显示"电线",如果出现"YJ",则显示"电缆",如果出现"K",则显示"控制电缆",如果是A列为空白则B列也为空白

奇果晓峰 发表于 2021-12-30 10:15:46

=LOOKUP(,-FIND({"","BV","YJ","K"},A2),{"","电线","电缆","控制电缆"})

姜明辉 发表于 2021-12-30 15:31:53

如果您的A列始终会夹杂有小写的话:
=IF(A2="","",LOOKUP(1,0/(FIND({"BV","YJ","K"},UPPER(A2))),{"电线","电缆","控制电缆"}))

伊万符豪 发表于 2022-1-19 04:30:27

=IF(A2="","",IF(COUNT(SEARCH("BV",A2)),"电线",IF(COUNT(SEARCH("YJ",A2)),"电缆",IF(COUNT(SEARCH("K",A2)),"控制电缆"))))

心情底色 发表于 2022-3-11 04:29:26

谢谢大神~~~~~~~~~~~~~~~~~~~

专说实话 发表于 2022-3-12 09:46:18

谢谢大神,按您这个公式解决问题了
页: [1]
查看完整版本: 求大神看看如何写公式?