当VLOOKUP返回空白值#N/A时我想要把返回的#N/A变成0,用函数该怎么弄答:则公式改成如下写法之一 =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返回空白值#N/A时我想要把返回的#N/A变成0,用函数该怎么...答:=VLOOKUP(C1,A:B,2,)\x0d\x0a则公式改成如下写法之一\x0d\x0a \x0d\x0a=IF(ISNA(VLOOKUP(C1,A:B,2,)),,VLOOKUP(C1,A:B,2,))\x0d\x0a \x0d\x0a=IF(ISERROR(VLOOKUP(C1,A:B,2,)),,VLOOKUP(C1,A:B,2,))\x0d\x0a \x0d\x0a=IF(COUMTIF(A:A,C1),VLOOKU...