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