Convert text in cell to a range name for formula
 

Suppose cell A1 contains a string that could be Table1, Table2, or Table3.
And that I have a vlookup for which I want to use the table specified in A1.
How do I specify that A1 represents a Table name and is not a table itself?
I can imagine a function of =namedrange(a1) which would return the range name
of Table1, Table2, or Table3 in vlookup(a10,namedrange(a1),2). But I cannot
find such a function. Does it exist? If not, what are the alternatives?

Convert text in cell to a range name for formula
 

Sawhney,

If I understand correctly, then Indirect will work:

=VLOOKUP(A10,INDIRECT(A1),2)

I should mention, Indirect does not work on closed workbooks.

hth,

Doug

"Sawhney" wrote in message
...
Suppose cell A1 contains a string that could be Table1, Table2, or Table3.
And that I have a vlookup for which I want to use the table specified in
A1.
How do I specify that A1 represents a Table name and is not a table
itself?
I can imagine a function of =namedrange(a1) which would return the range
name
of Table1, Table2, or Table3 in vlookup(a10,namedrange(a1),2). But I
cannot
find such a function. Does it exist? If not, what are the alternatives?