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
|