"IF(ISERROR(VLOOKUP(F2,[BOPlist.xls]VIP!$D:$D,1,FALSE)),"","

来源：学生作业帮编辑：大师作文网作业帮分类：综合作业时间：2024/11/06 08:10:09

"IF(ISERROR(VLOOKUP(F2,[BOPlist.xls]VIP!$D:$D,1,FALSE)),"","VIP")" 什么意思?

由内到外,一层层地看：
VLOOKUP(F2,[BOPlist.xls]VIP!$D:$D,1,FALSE)：
在VIP!$D:$D的查找F2,如果找到了就返回对应的D列值,没找到就得到错误值#N/A
ISERROR(VLOOKUP(F2,[BOPlist.xls]VIP!$D:$D,1,FALSE))
ISERROR是信息函数,判断是否为错误,得到TRUE或者FALSE.
这一段对上述结果进行判断,其中#N/A的部分得到TRUE.
最后用IF函数得到两种不同结果,没找到的显示为空,找到的显示VIP.

"IF(ISERROR(VLOOKUP(F2,[BOPlist.xls]VIP!$D:$D,1,FALSE)),""," =+IF(ISERROR(VLOOKUP(A100,[1304结存数量.XLS]金额!$A$1:$D$500,4,FAL =IF(ISERROR(AND(VLOOKUP(D3,表2!D:D,1,FALSE),VLOOKUP(I3,表2!I:I ISERROR(AND(VLOOKUP(D3,表2!D:D,1,FALSE),VLOOKUP(I3,表2!I:I,1,F =IF(ISERROR(VLOOKUP(B2,$D$1:$E$3960,2,0)),"",VLOOKUP(B2,$D$1 =IF(ISERROR(VLOOKUP($B4,平开窗!$A:$C,1,FALSE)),"",(VLOOKUP($B4, =IF(ISERROR(VLOOKUP($M2,明细!A:D,4,0)),"",VLOOKUP($M2,明细!A:D,4 =IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$ =IF(ISERROR(VLOOKUP(B4,单价表!A:C,3,FALSE)),"",VLOOKUP(B4,单价表!A =IF(ISERROR(VLOOKUP(B23,'2'!B:E,4,FALSE)),"",VLOOKUP(B23,'2' 函数公式=IF(ISERROR(VLOOKUP(E7,$A$6:$C$23,3,FALSE)),"0",VLOOKUP( =IF(ISERROR(VLOOKUP(E7,$A$6:$C$23,3,FALSE)),"0",VLOOKUP(E7,$