求大神看看如何写公式？

成梦听雨

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

奇果晓峰

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

姜明辉

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

伊万符豪

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

心情底色

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

专说实话

谢谢大神，按您这个公式解决问题了