OK I am giving up on the varible tale array. So I will make 20 tables. Now, how can I direct the VLOOKUP to the correct table without using 20 if()'s?
OK I am giving up on the varible tale array. So I will make 20 tables. Now, how can I direct the VLOOKUP to the correct table without using 20 if()'s?
You can make use of the INDIRECT function. If your tables are named in
some regular way, (eg table_a, table_b, table_c etc), then you should
be able to compute the table you look at. Presumably there would be
some condition to choose the appropriate table?
Hope this helps.
Pete
spxer wrote:
> OK I am giving up on the varible tale array. So I will make 20 tables.
> Now, how can I direct the VLOOKUP to the correct table without using 20
> if()'s?
>
>
> --
> spxer
> ------------------------------------------------------------------------
> spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
> View this thread: http://www.excelforum.com/showthread...hreadid=568347
I've just read the thread you were referring to, and have left a
message there which might also be of relevance to you.
Pete
Pete_UK wrote:
> You can make use of the INDIRECT function. If your tables are named in
> some regular way, (eg table_a, table_b, table_c etc), then you should
> be able to compute the table you look at. Presumably there would be
> some condition to choose the appropriate table?
>
> Hope this helps.
>
> Pete
>
> spxer wrote:
> > OK I am giving up on the varible tale array. So I will make 20 tables.
> > Now, how can I direct the VLOOKUP to the correct table without using 20
> > if()'s?
> >
> >
> > --
> > spxer
> > ------------------------------------------------------------------------
> > spxer's Profile: http://www.excelforum.com/member.php...o&userid=37025
> > View this thread: http://www.excelforum.com/showthread...hreadid=568347
I tried INDIRECT() as suggested by daddylonglegs, but I could not get it to work. I will try, try again. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks