求大神看看如何写公式?
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)),"控制电缆")))) 谢谢大神~~~~~~~~~~~~~~~~~~~ 谢谢大神,按您这个公式解决问题了
页:
[1]