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

来源:学生作业帮助网 编辑:六六作业网 时间:2025/02/01 07:38:00
=IF(ISNA(VLOOKUP(A2,表一!A2:B78,2,0)),"",VLOOKUP(A2,表一!A2:B78,2,0))直接下拉会从表一A3开始何解我是想他下拉后是=IF(ISNA(VLOO

=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,
=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))那么就会漏掉一些数据,该怎么改呢?我是新手才翻的书,请详解,

=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,
具体如何做,请HI我或把文件发[email protected]