当VLOOKUP返回空白值#N/A时我想要把返回的#N/A变成0,用函数该怎么弄_百...答:假设你的公式是 =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,...