问题描述
我在使用间接函数时遇到问题.
I'm having trouble with the usage of Indirect function.
这就是我要找的东西,我正在尝试根据当前选项卡创建动态查找.
Here's what i'm looking for, I'm trying to create a dynamic vlookup based on the current tab.
=VLOOKUP(B3;'NH BBC'!$E$1:$Z$188;MATCH("Share Out Out";'NH BBC'!$E$1:$Z$1;0);0)代码>
我的计划是通过 'NH' & 修改
假设我的标签的名称是'NH BBC'
RIGHT(CELL("filename");3)XXX_BBC
.
My plan is to modify the 'NH BBC'
by 'NH ' & RIGHT(CELL("filename");3)
Supposing that the name of my tab is XXX_BBC
.
我试过使用间接函数,但我不确定我的方法是否正确.
I've tried to use indirect function but I'm not sure I'm on the good way.
这是我尝试过的:
=VLOOKUP(B3;INDIRECT("'" "NH" & "RIGHT(CELL("'" & "filename" & "'" & ");3)" & "!" & "E1:Z188");MATCH("Share Out Out";'NH BBC'!$E$1:$Z$1;0);0)
希望我说的很清楚.
提前致谢!
推荐答案
我终于找到了,这个公式完美运行.
I've finally found and this formula is working perfectly.
VLOOKUP($B3;INDIRECT("'NH "&RIGHT(CELL("filename");3)&"'!$G$1:$ZZ$9999");MATCH("SHARE_OUTSTANDING";INDIRECT("'NH "&RIGHT(CELL("filename");3)&"'!$G$1:$ZZ$1");0))
顺便说一下,我遇到的问题是,当我在另一个选项卡中使用公式时,单元格正在发生变化.这可以查看我获得的价值吗?
By the way the issue i've got is that the cell are changing when i'm using the formula in another tab. Is this possible to look the value i've obtained ?
类似于 F9 的东西?
Something like a F9 ?
这篇关于使用间接的动态 Vlookup的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!