Choose Table then lookup values

Question

Choose Table then lookup values

MEM1 (Civil/Environmental)

(OP)

19 Oct 04 17:35

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 (Computer) · Answer 1 · 2004-10-19 18:42:59

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 (Structural) · Answer 2 · 2004-10-19 19:40:43

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!

Come Join Us!

Posting Guidelines

Choose Table then lookup values