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

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

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