my indirect function works but it returns a value error when I but the product function in front of it.
(INDIRECT("'eVestment Data'!"&SUBSTITUTE(ADDRESS(1,((Y2-D3+1)*12+2),4),"1","")&ROW('eVestment Data'!A60)&":"&SUBSTITUTE(ADDRESS(1,MATCH($C3,'eVestment Data'!59:59,0),4),"1","")&60)) this formula works but as soon as i add product( 1+ Indirect...), it no longer works. Attached is the excel file
Solved by T. J. in 25 mins