INDIRECT function

[Alberto Pinto]

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

 

[JE McGimpsey]

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

 

[Alberto Pinto]

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

Thanks and excuse me please