假设你的公式是 =VLOOKUP(C1,A:B,2,)
则公式改成如下写法之一
=IF(ISNA(VLOOKUP(C1,A:B,2,)),,VLOOKUP(C1,A:B,2,))
=IF(ISERROR(VLOOKUP(C1,A:B,2,)),,VLOOKUP(C1,A:B,2,))
=IF(COUMTIF(A:A,C1),VLOOKUP(C1,A:B,2,),)
=IF(ISNA(MATCH(C1,A:A,)),,VLOOKUP(C1,A:B,2,))
=IF(ISERROR(MATCH(C1,A:A,)),,VLOOKUP(C1,A:B,2,))
=IF(COUNT(MATCH(C1,A:A,)),VLOOKUP(C1,A:B,2,),)
温馨提示:答案为网友推荐,仅供参考