=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,明细!表示什么意

=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,