Get Range to Lookup from a Lookup table

[JG Scott]

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?

 

[JE McGimpsey]

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...

 

[JG Scott]

Thanks very much!!