software

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

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

cpearson.com/excel/newposte.htmIn article gt;,
Alberto Pinto gt; wrote:

gt; Hi!
gt;
gt; is it possible to return this kind of string from the indirect function
gt; (to use in a LOOKUP function):
gt;
gt; 'VARIABLE'!B$13:B$46
gt;
gt; where VARIABLE is in the cell A1, and gives me the worksheet to lookup
gt; the values.
gt;
gt; Thanks in advance

JE McGimpsey wrote:
gt; Take a look at one answer in microsoft.public.excel.links
gt;
gt; Please don't post the same message to multiple groups. It tends to
gt; fragment any answers you get, and it potentially wastes the time of
gt; those answering questions that have already been answered.
gt;
gt; For tips on using these groups effectively, see
gt;
gt; cpearson.com/excel/newposte.htm
gt;
gt;
gt; In article gt;,
gt; Alberto Pinto gt; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; is it possible to return this kind of string from the indirect function
gt;gt; (to use in a LOOKUP function):
gt;gt;
gt;gt; 'VARIABLE'!B$13:B$46
gt;gt;
gt;gt; where VARIABLE is in the cell A1, and gives me the worksheet to lookup
gt;gt; the values.
gt;gt;
gt;gt; Thanks in advance
Thanks and excuse me please