Indirect function help
 

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

Indirect function help
 

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

--
Biff
Microsoft Excel MVP


"Marc W" wrote in message
...
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

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

Indirect function help
 

Thanks I got it right eventually
--
Marc


"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