I am having a problem with an Index formula that uses an INDIRECT command to look for a named.
The formula works if I use the named range directly, but when using the INDIRECT command in the formula if returns #N/A.
Here is the formula
=INDEX(CY_SALES_ACCOUNT,MATCH(1,INDEX((INDIRECT("CY_SALES_"&'Control Sheet'!F8)=LARGE(CY_SALES_SEPTEMBER,ROWS(A$6:A6)))*(COUNTIF(A$5:A5,CY_SALES_ACCOUNT)=0),0)))
The named range I am testing with is CY_SALES_SEPTEMBER I am using this formula =OFFSET(Current!$K$4,0,0,COUNTA(Current!$K:$K)-2,1)
I could use some pointer of what to do with this problem.
Thanks
Bookmarks