INDIRECT function

A

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
 
J

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
 
A

Alberto Pinto

JE said:
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
Click to expand...
Thanks and excuse me please
 
Top