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