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