#NA Error in index function when using the indirect function to get a named range.

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

It would help to know what the working formula looks like, the name of the Named Range, and then content of the Named Range.

Ideally, please see the yellow banner at the top of the page.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Have you tried to confirm the array formula by Ctrl-Shift-Enter Combination? Try it.
If it does not work, try to post a sample WS.

Can't help with why the INDIRECT(named range... formula isn't working, however perhaps this could be used instead.
On the Current sheet convert the range A3:N16 into a table.
Use the following formula in cells B3 and down on Sheet3:

Formula:

=IFERROR(INDEX(Table1[Account Number],MATCH(1/(1/LARGE(INDEX(Table1[[January]:[December]],,MATCH(ctrl_CurMo,Table1[[#Headers],[January]:[December]],0)),ROWS(A$6:A6))),INDEX(Table1[[January]:[December]],,MATCH(ctrl_CurMo,Table1[[#Headers],[January]:[December]],0)),0)),"")

Let us know if you have any questions.