=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误",VLOOKUP($E$2,明细!表示什么意

来源：学生作业帮助网编辑：六六作业网时间：2024/05/04 10:06:51

=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE))=TRUE,"编号错误",VLOOKUP($E$2,明细!表示什么意=IF(ISNA(VLOOKUP($E

=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误",VLOOKUP($E$2,明细!表示什么意
=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误",VLOOKUP($E$2,明细!表示什么意

=IF(ISNA(VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)) = TRUE,"编号错误",VLOOKUP($E$2,明细!表示什么意
VLOOKUP($E$2,明细!$A$3:$G$1500,2,FALSE)
用E2单元格在表明细里的A3到A1500里查找相同数值.如果有则返回明细表B列对应行号的数值.如果没有就会返回#N/A,