=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误
=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误
=IF(ISNA(VLOOKUP(B2,Sheet2!$A$1:$E$10000,4,FALSE))=TRUE,"",V
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP(
=IF(ISNA(VLOOKUP($B7,'\\Sheet1'!$B:$L,2,FALSE)),0,VLOOKUP($B
excel匹配函数 =IF(ISNA(VLOOKUP(A2,Sheet1!A$1:AZ$9999,19,FALSE)),
谁知道 EXCEL表格这个公式是什么意思 IF(ISERROR(VLOOKUP(B14,编号!A:E,2,FALSE))
=IF(ISNA(VLOOKUP($B$1,'5月1日'!$F$2:$J$50,5,FALSE)),"0",VLOOKU
=IF(ISNA(VLOOKUP(K8,'1月'!D:E,2,0)),"",VLOOKUP(K8,'1月'!D:E,2,
=IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$
=IF(ISERROR(VLOOKUP(B23,'2'!B:E,4,FALSE)),"",VLOOKUP(B23,'2'
=IF(ISNA(VLOOKUP(F20&"",$A$18:$C$22,3,0)),VLOOKUP(F20*1,$A$1
=IF(ISNA(VLOOKUP(R$2&$A7,随时更新!$A:$B,2,0)),0,VLOOKUP(R$2&$A7,