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

One way:

=LOOKUP(A2,INDIRECT(quot;'quot; amp; A1 amp; quot;'!B13:B36quot;),$J$13:$J$36)

In 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; One way:
gt;
gt; =LOOKUP(A2,INDIRECT(quot;'quot; amp; A1 amp; quot;'!B13:B36quot;),$J$13:$J$36)
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