Calling a sheet from a cell

[freeinfo]

Hi everyone,

I tried searching the internet for this one but no luck. I'm trying to use the index-match-match function while calling another sheet. For simplicity here's an example: =INDEX('Q215'!A3:A4,1,1).

So in this case, the sheet being called is "Q215." However, I need to call many different sheets with a different name for each quarter. Instead of changing the sheet name manually I would like to point it to a cell, but everything I have tried has ended as an error. What I would like is for the formula to end up looking like/or working in such a way as: =INDEX('(selected cell calls sheet Q215)'!A3:A4,1,1).

Any help would be much appreciated. Thanks!

Hugh

[NeedForExcel]

Try this

=INDEX(INDIRECT("'"&A2&"'!A3:A4"),1,1)

Assuming A2 has your sheet name

See the file attached

[:) Sixthsense :)]

Enter your sheet name in C1 cell

=INDEX(INDIRECT("'"&C1&"'!A3:A4"),1,1)

Change the C1 cell reference to your desired, cell if required.

[freeinfo]

Thanks guys!

Now I also see why it didn't work for me before. I had tried using the indirect formula but I put the last quotation mark before the target array instead of after. Works great now!

Take care and thanks again,

Hugh