| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
lookup function, in which the table's name is including in ano
Thank you very much
Giannis Ο χρήστης "Niek Otten" *γγραψε: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple lookup including date range | Excel Worksheet Functions | |||
| lookup on Table including blanks - | Excel Worksheet Functions | |||
| Subtraction when including the MOD() function | Excel Worksheet Functions | |||
| Workday function including sat, excluding sun | Excel Worksheet Functions | |||
| Function to find closest to 0 (including neg #'s) in cloumn | Excel Discussion (Misc queries) | |||
Linear Mode
