使用间接的动态 Vlookup [英] Dynamic Vlookup with usage of indirect

问题描述

我在使用间接函数时遇到问题.

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的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！