Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |