问题描述:
=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(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))那么就会漏掉一些数据,该怎么改呢?我是新手才翻的书,请详解,
问题解答:
我来补答展开全文阅读