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

[Giannis]

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

 

[T. Valko]

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

INDIRECT(K1)

 

[Niek Otten]

Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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

 

[Giannis]

Thank you very much

Giannis

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