Question

=IF(ISNA(VLOOKUP(A2,表一!A2:B78,2,0)),"",VLOOKUP(A2,表一!A2:B78,2,0))直接下拉会从表一A3开始何解

我是想他下拉后是=IF(ISNA(VLOOKUP(A3,表一!A2:B78,2,0)),"",VLOOKUP(A3,表一!A2:B78,2,0))但实际下拉后是=IF(ISNA(VLOOKUP(A3,表一!A3:B79,2,0)),"",VLOOKUP(A3,表一!A3:B79,2,0))那么就会漏掉一些数据，该怎么改呢？我是新手才翻的书，请详解，谢谢

Answer 1

假设第一行为标题行，组一的数据在Sheet1的A、B列，组二的数据在Sheet2的A、B列
在Sheet2的B2输入公式“=IF(ISERROR(VLOOKUP(A2,SHEET1!A:B,2,FALSE)),"",VLOOKUP(A2,SHEET1!A:B,2,FALSE))”，再向下填充即可。
试试吧，有问题讨论，祝你成功！

追问

我是想他下拉后是=IF(ISNA(VLOOKUP(A3,表一!A2:B78,2,0)),"",VLOOKUP(A3,表一!A2:B78,2,0))但实际下拉后是=IF(ISNA(VLOOKUP(A3,表一!A3:B79,2,0)),"",VLOOKUP(A3,表一!A3:B79,2,0))那么就会漏掉一些数据，该怎么改呢？新手，请详解，谢谢

Answer 2

具体如何做，请HI我或把文件发sm100e@qq.com