IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 面的2,0

=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP( IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A =IF(ISNA(VLOOKUP($B7,'\\Sheet1'!$B:$L,2,FALSE)),0,VLOOKUP($B =IF(ISNA(VLOOKUP($B$1,'5月1日'!$F$2:$J$50,5,FALSE)),"0",VLOOKU VLOOKUP公式公式是这样的=VLOOKUP(F:F,F:G,2,0),是同表中的查找,不是很理解, =IF(ISNA(VLOOKUP(R$2&$A7,随时更新!$A:$B,2,0)),0,VLOOKUP(R$2&$A7, =IF(ISNA(VLOOKUP(K8,'1月'!D:E,2,0)),"",VLOOKUP(K8,'1月'!D:E,2, =IF(ISNA(VLOOKUP(A2,表一!A2:B78,2,0)),"",VLOOKUP(A2,表一!A2:B78, =IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误 =IF(ISNA(VLOOKUP(C:C,前15天销售!D:F,3,FALSE)),0,VLOOKUP(C:C,前15天 =IF(ISNA(VLOOKUP(A2,Sheet2!B:B,1,0)),"",VLOOKUP(A2,Sheet2!B: =IF(ISNA(VLOOKUP(F20&"",$A$18:$C$22,3,0)),VLOOKUP(F20*1,$A$1