Indirect function help

[Marc W]

Hi, can anyone help with this problem:
I have worksheets named 1 - 12 and also one named quality.
How would I include the Indirect function in the following to return data
from the sheet number I enter in cell 'A1' on my quality sheet.

=INDEX($B$2:$T$44,MATCH($M$55,$A$2:$A$47,0),MATCH(1,IF($B$2:$N$2=$M$56,IF($B$5:$T$5='36'!$M$57,1)),0))


Thanks

 

[T. Valko]

In the formula you posted, which references are on the other sheets?

 

[Jacob Skaria]

Before each cell reference use

=INDIRECT("'" & A1 & "'!A1")
A1 will have the sheet name..

If this post helps click Yes

 

[Marc W]

Thanks I got it right eventually