作业帮 > 综合 > 作业

=IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$

来源：学生作业帮 编辑：作业帮 分类：综合作业 时间：2024/05/16 16:20:57
=IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$A$2:$B$2500,3,FALSE))
有两列数据,一列是客户编号,一列是客户名称.现在我需要根据客户编号抽取客户名称,上面的公式不能抽取汉字内容,请教高手需要怎么修改公式!
财富不多,
把3改为2试试!
=IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,2,FALSE)),0,VLOOKUP(E2,$A$2:$B$2500,2,FALSE))
=IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$ =IF(ISERROR(VLOOKUP(A2,基础表!A:B,2,FALSE) 0,VLOOKUP(A2,基础表!A:B 函数公式=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,$ =IF(E2="","",VLOOKUP(E2,表二!A4:D14,3,FALSE)) =IF(ISERROR(VLOOKUP(B23,'2'!B:E,4,FALSE)),"",VLOOKUP(B23,'2' 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($B:$B,数据源!A:B,2,0)),0,VLOOKUP($B:$B,数据源! =IF(ISERROR(VLOOKUP($B4,平开窗!$A:$C,1,FALSE)),"",(VLOOKUP($B4, =IF(ISERROR(VLOOKUP($B5,基本信息,2,FALSE)),"",VLOOKUP($B5,基本信息,2