Indirect function help
Before each cell reference use
=INDIRECT("'" & A1 & "'!A1")
A1 will have the sheet name..
If this post helps click Yes
---------------
Jacob Skaria
"Marc W" wrote:
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
|