Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT function
Hi!
is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT function
Take a look at one answer in microsoft.public.excel.links
Please don't post the same message to multiple groups. It tends to fragment any answers you get, and it potentially wastes the time of those answering questions that have already been answered. For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm In article , Alberto Pinto wrote: Hi! is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT function
JE McGimpsey wrote:
Take a look at one answer in microsoft.public.excel.links Please don't post the same message to multiple groups. It tends to fragment any answers you get, and it potentially wastes the time of those answering questions that have already been answered. For tips on using these groups effectively, see http://cpearson.com/excel/newposte.htm In article , Alberto Pinto wrote: Hi! is it possible to return this kind of string from the indirect function (to use in a LOOKUP function): 'VARIABLE'!B$13:B$46 where VARIABLE is in the cell A1, and gives me the worksheet to lookup the values. Thanks in advance Thanks and excuse me please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
Using Indirect Function | Excel Worksheet Functions | |||
INDIRECT function question | Excel Worksheet Functions | |||
Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions |