VLOOKUP with dynamic sheet name

[cazellnu]

Hi All:

I understand that there are thousand ways to customerize the vlookup parameter. However, if there is anyway that I can reference the table array by the following:

vlookup(a1, [some sheet name reference by the cell]!A:A, 1, false).

Any suggestion would be extremely helpful

Regards.

 

[SkipVought]

Hi,

Indirect function
[tt]
vlookup(a1,INDIRECT([some sheet name reference by the cell]&"!A:A"), 1, false).
[/tt]



Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}