动态Vlookup与间接使用 [英] Dynamic Vlookup with usage of indirect
问题描述
我使用间接功能时遇到麻烦。
I'm having trouble with the usage of Indirect function.
这是我正在寻找的,我正在尝试创建一个动态的vlookup,基于当前标签
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 Outstanding NH BBC'!$ E $ 1:$ Z $ 1; 0); 0)
我的计划是修改'NH BBC'
by 'NH'& 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 Outstanding;NH BBC!$ E $ 1:$ Z $ 1; 0); 0 )
希望我已经清楚了。
提前感谢! / p>
Thanks in advance !
推荐答案
我终于找到了,这个公式正常工作。
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这样的东西?
这篇关于动态Vlookup与间接使用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!