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
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.