Get Range to Lookup from a Lookup table

J

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?
 
J

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?
Click to expand...

Only if this example helps...
 
Top