你好!EXCEL,关于VLOOKUP/INDIRECT,结果显示#VALUE!的问题.=IF(ISNA(VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0)),"",VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0))
来源:学生作业帮助网 编辑:作业帮 时间:2024/09/01 15:19:47
你好!EXCEL,关于VLOOKUP/INDIRECT,结果显示#VALUE!的问题.=IF(ISNA(VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0)),"",VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0))
你好!EXCEL,关于VLOOKUP/INDIRECT,结果显示#VALUE!的问题.
=IF(ISNA(VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0)),"",VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0)) 结果显示#VALUE!是为什么呢?我想找的是,Sheet4里E5对应II465的值.
你好!EXCEL,关于VLOOKUP/INDIRECT,结果显示#VALUE!的问题.=IF(ISNA(VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0)),"",VLOOKUP(COLUMN(A1),INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")):$II$465,240-ROW(A1),0))
INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4"))和:$II$465直接连起来写是不对的.改成下面的就行了.
INDIRECT(ADDRESS(3,4+ROW(A1),4,1,"Sheet4")&“:$II$465”)
也就是在indirect里要用字符串把引用拼完整.