Convert text in cell to a range name for formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top