software

I have the following formula which works fine:

=INDEX(February!A1:Z100,MATCH(quot;USDquot;,February!A:A,0 ),MATCH(quot;AUDquot;,February!4:4,0))

I would like February to be the variable contents of a particular cell but
cant get my referencing right. Can anyone please help??

You may try this with Indirect (supposing quot;Februaryquot; is on cell AA1):
=INDEX(INDIRECT(AA1 amp; quot;!A1:Z100quot;),MATCH(quot;USDquot;,INDIRECT(AA1 amp;
quot;!A:Aquot;),0),MATCH(quot;AUDquot;,INDIRECT(AA1 amp; quot;!4:4quot;),0))

quot;Newbiequot; wrote:

gt; I have the following formula which works fine:
gt;
gt; =INDEX(February!A1:Z100,MATCH(quot;USDquot;,February!A:A,0 ),MATCH(quot;AUDquot;,February!4:4,0))
gt;
gt; I would like February to be the variable contents of a particular cell but
gt; cant get my referencing right. Can anyone please help??

Thanks Miguel.

=INDEX(INDIRECT(AA1 amp; quot;!A1:Z100quot;),MATCH(quot;USDquot;,INDIRECT(AA1 amp;
quot;!A:Aquot;),0),MATCH(quot;AUDquot;,INDIRECT(AA1 amp; quot;!4:4quot;),0))

quot;Miguel Zapicoquot; wrote:

gt; You may try this with Indirect (supposing quot;Februaryquot; is on cell AA1):
gt; =INDEX(INDIRECT(AA1 amp; quot;!A1:Z100quot;),MATCH(quot;USDquot;,INDIRECT(AA1 amp;
gt; quot;!A:Aquot;),0),MATCH(quot;AUDquot;,INDIRECT(AA1 amp; quot;!4:4quot;),0))
gt;
gt; quot;Newbiequot; wrote:
gt;
gt; gt; I have the following formula which works fine:
gt; gt;
gt; gt; =INDEX(February!A1:Z100,MATCH(quot;USDquot;,February!A:A,0 ),MATCH(quot;AUDquot;,February!4:4,0))
gt; gt;
gt; gt; I would like February to be the variable contents of a particular cell but
gt; gt; cant get my referencing right. Can anyone please help??