indirect, index, match formula

[jas1980]

I have been using this index match formula in one of my sheets for a while, recently I tried to add indirect to it so it gets the sheet in use from a cell, I must have done something wrong because I cannot get the following formula to work.

Could someone please show me where I have gone wrong, thanks.

=INDEX(INDIRECT("'"&BR15&"'!$C$10:$J$3000",MATCH(INDIRECT(J17,"'"&BR15&"'!$J$10:$J$3000",0),1))

 

[steve the fish]

Try this:

=INDEX(INDIRECT("'"&BR15&"'!$C$10:$J$3000"),MATCH(J17,INDIRECT("'"&BR15&"'!$J$10:$J$3000"),0),1)

 

[jas1980]

Try this:

=INDEX(INDIRECT("'"&BR15&"'!$C$10:$J$3000"),MATCH(J17,INDIRECT("'"&BR15&"'!$J$10:$J$3000"),0),1)

Perfect thankyou, works as needed.