Bugfix 15290
diff --git a/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs b/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs index 28a9116..af85a06 100644 --- a/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs +++ b/EPPlus/FormulaParsing/Excel/Functions/RefAndLookup/Indirect.cs
@@ -45,7 +45,9 @@ var result = context.ExcelDataProvider.GetRange(ws, adr._fromRow, adr._fromCol, address); if (result.IsEmpty) { - return CompileResult.Empty; + // Bug 15290 + var namedValueExpr = new NamedValueExpression(address, context); + return namedValueExpr.Compile(); } return new CompileResult(result, DataType.Enumerable); }