Get Range to Lookup from a Lookup table

Does someone have an example of using one lookup table to provide the
range for another lookup table?

PS Is this not easier than my providing all the details of my
situation, most of which are irrelevant to the question?

One way:

Given: Tables named table1, table2, etc. Cell named tableswitch. table1
is:

J K
1 A table2
2 B table3
3 C table4
4 ....

=VLOOKUP(A1, INDIRECT(VLOOKUP(tableswitch, table1, 2)), 2, FALSE)

> PS Is this not easier than my providing all the details of my
> situation, most of which are irrelevant to the question?

Only if this example helps...

In article <[email protected]>,
"JG Scott" <[email protected]> wrote:

> Does someone have an example of using one lookup table to provide the
> range for another lookup table?
>
> PS Is this not easier than my providing all the details of my
> situation, most of which are irrelevant to the question?

Thanks very much!!