Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using INDIRECT Function and INDEX Function | Excel Discussion (Misc queries) | |||
INDIRECT function | Excel Discussion (Misc queries) | |||
INDIRECT function inside AND function | Excel Worksheet Functions | |||
Function INDIRECT | Excel Worksheet Functions | |||
Help with INDIRECT function. | Excel Worksheet Functions |