Created attachment 35753 [details] Sample file to replicate the problem Referring a named range in a different sheet using from an INDIRECT causes NPE. The problem seems that the “OperationEvaluationContext” is searching the name in the referee sheet (the one containing the formula) instead of the owner of the name. See the suggested patch for details.
Created attachment 35754 [details] Unit test to replicate the issue
Created attachment 35755 [details] Possible solution