One way via INDIRECT & named table_arrays

Name* the lookup table_arrays as say:
Table1, Table2, Table3, Table4, etc
*via Insert Name Define, or via the namebox

Then we could use these names as labels in B1:E1
and deploy something like this in B2:
=VLOOKUP($A2,INDIRECT(B$1),2,0)
to return from Table1 in col B

B2 could then simply be copied across and filled down to return
correspondingly from the names entered in C1:E1, viz from: Table2, Table3,
Table4 in cols C to E
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"joeldsmt" wrote:
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