=IF(ISNA(VLOOKUP(C:C,前15天销售!D:F,3,FALSE)),0,VLOOKUP(C:C,前15天

来源：学生作业帮编辑：神马作文网作业帮分类：综合作业时间：2024/11/10 03:02:43

=IF(ISNA(VLOOKUP(C:C,前15天销售!D:F,3,FALSE)),0,VLOOKUP(C:C,前15天销售!D:F,3

应该是=IF(ISNA(VLOOKUP(C:C,前15天销售!D:F,3,FALSE)),0,VLOOKUP(C:C,前15天销售!D:F,3,FALSE))吧?
你没有说具体是什么内容,所以说起来比较难,我现设你C列的数据是销售员人名,工作表“前15天销售”是各个销售员的销售成绩表,它的F列是就是销售成绩.
意思是在“前15天销售”这个工作表中,查找此公式对应那一行中C列的人的销售记录,如果找到就显示此人的销售成绩,没找到就显示0.

=IF(ISNA(VLOOKUP(C:C,前15天销售!D:F,3,FALSE)),0,VLOOKUP(C:C,前15天 =IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP( =IF(ISNA(VLOOKUP(F20&"",$A$18:$C$22,3,0)),VLOOKUP(F20*1,$A$1 函数公式=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,$ =VLOOKUP(A2,C:D,2,FALSE) 这个公式函数 =IF(ISNA(VLOOKUP(D2,旅客名册!A:C,3,0)),"",VLOOKUP(D2,旅客名册 IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A IF(ISERROR(VLOOKUP(E7,$A$6:$C$23,3,FALSE)),"0",VLOOKUP(E7,$A =IF(ISERROR(VLOOKUP(B4,单价表!A:C,3,FALSE)),"",VLOOKUP(B4,单价表!A =IF(ISERROR(VLOOKUP(D5,Sheet4!A:C,3,FALSE)),"",VLOOKUP(D5,Sh =IF(ISERROR(VLOOKUP($B4,平开窗!$A:$C,1,FALSE)),"",(VLOOKUP($B4,