如何去掉=IF(ISNA(VLOOKUP(G:G,A:B,2,0)),VLOOKUP(G:G,D:E,2,0),VLOO
来源:学生作业帮 编辑:搜搜做题作业网作业帮 分类:综合作业 时间:2024/07/23 00:52:33
如何去掉=IF(ISNA(VLOOKUP(G:G,A:B,2,0)),VLOOKUP(G:G,D:E,2,0),VLOOKUP(G:G,A:B,2,0))产生的#N/A
去掉#N/A 的已经解决
但是如果在这个表里面A列里面有重复的,那么该怎么办?
去掉#N/A 的已经解决
但是如果在这个表里面A列里面有重复的,那么该怎么办?
![如何去掉=IF(ISNA(VLOOKUP(G:G,A:B,2,0)),VLOOKUP(G:G,D:E,2,0),VLOO](/uploads/image/z/16500905-17-5.jpg?t=%E5%A6%82%E4%BD%95%E5%8E%BB%E6%8E%89%3DIF%28ISNA%28VLOOKUP%28G%3AG%2CA%3AB%2C2%2C0%29%29%2CVLOOKUP%28G%3AG%2CD%3AE%2C2%2C0%29%2CVLOO)
用这个公式的时候要找的数据就不能重复,应该是唯一的.如果是重复的,只显示第一个.你最好编个序号.或者是用身份证信息.上面去掉#N/A的问题,你还可以这样做:在显示有#N/A的后面一列,“=if(iserror(点击前一列)=true,"",前一列的值)”你可以试一下.
=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误
=IF(ISNA(VLOOKUP(K8,'1月'!D:E,2,0)),"",VLOOKUP(K8,'1月'!D:E,2,
=IF(ISNA(VLOOKUP($B7,'\\Sheet1'!$B:$L,2,FALSE)),0,VLOOKUP($B
=IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP(
=IF(ISNA(VLOOKUP(R$2&$A7,随时更新!$A:$B,2,0)),0,VLOOKUP(R$2&$A7,
IF(ISNA(VLOOKUP(A:A,sheet1!A:C,2,0)),"",VLOOKUP(A:A,sheet1!A
=IF(ISNA(VLOOKUP(D2,通信录!A:B,1,0)),"",VLOOKUP(D2,通信录!A:B,1,
=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
=IF(ISERROR(VLOOKUP(B2,$D$1:$E$3960,2,0)),"",VLOOKUP(B2,$D$1
=IF(ISNA(VLOOKUP(A2,表一!A2:B78,2,0)),"",VLOOKUP(A2,表一!A2:B78,
=IF(ISERROR(VLOOKUP($B:$B,数据源!A:B,2,0)),0,VLOOKUP($B:$B,数据源!