Indirect Formula Help -- I think

[NicholasP]

I think this is an easy indirect formula solution, but I'm not so good at using Indirect...

So I have this formula:

=INDEX('2011'!B3:H1000,MATCH(D4,'2011'!A3:A1000,0),MATCH(J3,'2011'!B2:H2,0))

And in the place of 2011, I would like to reference cell C4...

Any help would be greatly appreciated.

Thanks
Nick

 

[Robert Mika]

Try this:
=INDEX(INDIRECT("'" & C4 & "'!$B3:H1000"),MATCH(D4,"'" & C4 & "'!A3:A1000",0),MATCH(J3,"'" & C4 & "'!$B2:H2",0))

 

[Aladin Akyurek]

I think this is an easy indirect formula solution, but I'm not so good at using Indirect...

So I have this formula:

=INDEX('2011'!B3:H1000,MATCH(D4,'2011'!A3:A1000,0),MATCH(J3,'2011'!B2:H2,0))

And in the place of 2011, I would like to reference cell C4...

Any help would be greatly appreciated.

Thanks
Nick

To spare at least one INDIRECT call...

=VLOOKUP(D4,INDIRECT("'"&C4&"'!A2:H1000"),MATCH(J3,INDIRECT("'"&C4&"'!A2:H2"),0),0)

 

[NicholasP]

Thanks guys. I appreciate it.

 

[Aladin Akyurek]

Thanks guys. I appreciate it.

You are welcome. Thanks for providing us feedback.