Hello,

I dont have a clue what to do and any assistance would be greatly
appreciated. Here is what i want to do:

I presently have a worksheet that has for columns. Each column has a
look up table that it searches when i enter a specific number in column
A. So lets say i enter 2000 in column A.Column B will go to my first
look up table and get me a number. Columns C will go to my second
table, D will look at my third table, and E will look up my Fourth
table. This process is working just. The problem is this... I now
have more than 4 tables and only 4 columns to work with.

Is there a way that I can enter a Number on the top of any of these
columns and then the proper lookup table will be searched. For
instance if i enter #1 on the top of column B it will search my first
table, but if i enter #2 instead it will search my second table.

Any ideas?

Thank you all in advance.

JM


--
joeldsmt
------------------------------------------------------------------------
joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889
View this thread: http://www.excelforum.com/showthread...hreadid=560923