I have a named range AL_Year1_Nts.

If I type into a cell, =Max(AL_Year1_Nts) the formula works fine.

If I type Max(Indirect("AL_Year1_Nts")) I get #REF

If I type ="AL_Year1_Nts" into cell B1, and then in C1 type =Max(indirect(B1)) I also get #REF

I've also tried saving the cell as an array formula, but still throws the error. What am I not seeing here?

Thanks for any help. Mark