Choose Table then lookup values

[MEM1]

Hello all,

I have a series of tables identified by two different cells. I need to be able to choose which table I need by inputting these two numbers into cells, then lookup a value in the first column of the table and return the values in the same row for the next 15 columns. Is this possible? Thanks in advance

Scott

 

[Mala]

It should be quite possible to do this.

Please explain a bit more how the tables are laid out and how the two numbers you input identify which table to use.
Is it that one of the cells contains the table number and the other the value to be lookd up?


Mala Singh
'Dare to Imagine'

 

[yakpol]

Mem1,
One of the ways of accomplishing this task:
1. assign names to each lookup table.
2. in the certain cell (table_name_cell) write a formula returning the name of the table ( based on two input variables).
3. Use LOOKUP function or combination of MATCH and INDEX to map the chosen table refering to it by function INDIRECT(table_name_cell).

Good luck!