Thread: lookup function, in which the table's name is including in another
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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


Reply With QuoteReply With Quote