I'm trying to use this formula to put all my other sheets on one master/composite sheet, and I'm having some problems.
Could anyone help?
I'm trying to use this formula: =INDEX(INDIRECT("'"&INT((COLUMN()-5)/12)+1&"'!E6:L49"),MATCH($A3,INDIRECT("'"&INT((COLUMN()-5)/12)+1&"'!A6:A49"),0),MATCH(E$2,INDIRECT("'"&INT((COLUMN()-5)/12)+1&"'!E5:L5"),0))
Bookmarks