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?
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 <1129308087.736285.274890@z14g2000cwz.googlegroups.com>,
"JG Scott" <jgscott3@bellsouth.net> 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!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks