VlookUP Multiple tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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?action=getinfo&userid=11889
View this thread: http://www.excelforum.com/showthread.php?threadid=560923

.

Relevant Pages

  • Re: What do I do with the check?
    ... it cost them more to mail a bill and process a payment manually. ... of cash is not real safe, and carrying small amounts requires far too ... and dont have the risk of carrying large sums of cash. ... How odd that they havent managed to do that to anyone with a clue. ...
    (misc.consumers)