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

G

Guest

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
 
N

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
 
G

Guest

Thank you very much

Giannis

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HLookup, multiple tables and range names in other cells 2
Counting multiple values (including blanks) in one column 13
Multiple input data , multiple output data 7
Lookup function and compare 8
Cell contents as the 'lookup value' parameter in HLOOKUP function 3
Looking up a text string 5
Return Top Ranks For Certain Categories in Column 7
Globarlly use var (from linq) or anything equivalent ? 8

Top