ExcelBanter - INDIRECT

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INDIRECT (https://www.excelbanter.com/excel-discussion-misc-queries/86791-indirect.html)

I have the following formula which works fine:

=INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",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 "February" is on cell AA1):
=INDEX(INDIRECT(AA1 & "!A1:Z100"),MATCH("USD",INDIRECT(AA1 &
"!A:A"),0),MATCH("AUD",INDIRECT(AA1 & "!4:4"),0))

"Newbie" wrote:

I have the following formula which works fine:

=INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",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??

Thanks Miguel.

=INDEX(INDIRECT(AA1 & "!A1:Z100"),MATCH("USD",INDIRECT(AA1 &
"!A:A"),0),MATCH("AUD",INDIRECT(AA1 & "!4:4"),0))

"Miguel Zapico" wrote:

You may try this with Indirect (supposing "February" is on cell AA1):
=INDEX(INDIRECT(AA1 & "!A1:Z100"),MATCH("USD",INDIRECT(AA1 &
"!A:A"),0),MATCH("AUD",INDIRECT(AA1 & "!4:4"),0))

"Newbie" wrote:

I have the following formula which works fine:

=INDEX(February!A1:Z100,MATCH("USD",February!A:A,0 ),MATCH("AUD",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??