=IF(ISNA(VLOOKUP($A$1,订单台帐!$A:$U,12,FALSE))," ",(VLOOKUP($A$

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/20 05:05:53

=IF(ISNA(VLOOKUP($A$1,订单台帐!$A:$U,12,FALSE))," ",(VLOOKUP($A$1,订单台帐!$A:$U,12,FALSE)))
详细的解释三个函数（IF,ISNA,VLOOKUP）,它们各自的公式、意思及整体的意思.

if（a,b,c) If用来判断表达式a的真伪,真则返回b,否则返回c;
isna(d) 用来判断表达式是否为N/A,是则返回true,否则返回false；
vlookup（e,f,g,h) 用来查找针对对象e,在f单元格组的范围内,第g列的数,h是是否允许模糊匹配,一般填0,false也可
再问： isna判断N／A是什么？
再答：就是有时候vlookup返回的值是#N/A就是not available的简称，也即无法得到值

=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP( =IF(ISNA(VLOOKUP(B2,Sheet2!$A$1:$E$10000,4,FALSE))=TRUE,"",V excel匹配函数 =IF(ISNA(VLOOKUP(A2,Sheet1!A$1:AZ$9999,19,FALSE)), =IF(ISNA(VLOOKUP(F20&"",$A$18:$C$22,3,0)),VLOOKUP(F20*1,$A$1 =IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误 =IF(ISNA(VLOOKUP(D2,通信录!A:B,1,0)),"",VLOOKUP(D2,通信录!A:B,1, =IF(ISERROR(VLOOKUP($B4,平开窗!$A:$C,1,FALSE)),"",(VLOOKUP($B4, IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A =IF($B5="m",VLOOKUP($C5,make,8,FALSE),IF($B5="a",VLOOKUP($C5 =IF(ISERROR(VLOOKUP(B4,单价表!A:C,3,FALSE)),"",VLOOKUP(B4,单价表!A =IF(ISNA(VLOOKUP(D2,库存表!A:T,7,0)),,VLOOKUP(D2,库存表!A:T,7,“7,0 =IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$