lookup function, in which the table's name is including in another
 

I have 2 tables with names AA & BB.
In cell K1 i write the table's name (Aa or BB)
In cell L8 i could use a lookup function like (lookup_value;AA;row_index_num)
but instead of this i want to use something like
(lookup_value;K1;row_index_num)
How can i do this?

Sorry for my english.
Thank you

lookup function, in which the table's name is including in another
 

As long as the tables aren't dynamic ranges try it like this:

INDIRECT(K1)

--
Biff
Microsoft Excel MVP


"Giannis" wrote in message
...
I have 2 tables with names AA & BB.
In cell K1 i write the table's name (Aa or BB)
In cell L8 i could use a lookup function like
(lookup_value;AA;row_index_num)
but instead of this i want to use something like
(lookup_value;K1;row_index_num)
How can i do this?

Sorry for my english.
Thank you

lookup function, in which the table's name is including in another
 

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Giannis" wrote in message ...
|I have 2 tables with names AA & BB.
| In cell K1 i write the table's name (Aa or BB)
| In cell L8 i could use a lookup function like (lookup_value;AA;row_index_num)
| but instead of this i want to use something like
| (lookup_value;K1;row_index_num)
| How can i do this?
|
| Sorry for my english.
| Thank you

lookup function, in which the table's name is including in ano
 

Thank you very much

Giannis

Ο χÏ�ήστης "Niek Otten" Î*γγÏ�αψε:

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Giannis" wrote in message ...
|I have 2 tables with names AA & BB.
| In cell K1 i write the table's name (Aa or BB)
| In cell L8 i could use a lookup function like (lookup_value;AA;row_index_num)
| but instead of this i want to use something like
| (lookup_value;K1;row_index_num)
| How can i do this?
|
| Sorry for my english.
| Thank you