=IF(OR(ISNUMBER(FIND({"中石油","埃克森-美孚","微软","工商银行","苹果","巴西石油","宝洁","强生","美国银行","Tina","中国工商银行"},A3))),"Y","N") 你用这个公式试一下吧!!!下拉! 也可以用这个公式=IF(OR(ISNUMBER(FIND(表2关键字!$A$2:$A$12,A3))),"Y","N"),但用这个公式时,要注意三键结束ctrl+shift+enter 都是一样的结果!!!
[此贴子已经被作者于2010-10-19 22:46:45编辑过] |