Excel pads dynamic array output with #NV values

I have come across a couple of instances, where Excel 365 pads the output (of lambdas) or in this case of a specific formula within a lambda with #NV values (or errors if you like to treat them so.) ...

excel

Formulas and Functions

office 365

NikolinoDE

Jan 23, 2026

=LAMBDA(assemblyName;
 LET(
   filteredParams; {"a";"b";"c"};
   mappedValues; {1;2;3};
   stacked; HSTAPELN(filteredParams; mappedValues);  // 3x2 array
   transposed; MTRANS(stacked);                     // 2x3 array
   return; WENN(transposed = ""; "NV"; transposed); // Dimensions match (2x3)
   return
))("fake")

for eliminating the #NV padding.

Hope it helps 🙂

=LAMBDA(assemblyName; LET( filteredParams; {"a";"b";"c"}; mappedValues; {1;2;3}; stacked; HSTAPELN(filteredParams; mappedValues); // 3x2 array transposed; MTRANS(stacked); // 2x3 array return; WENN(transposed = ""; "NV"; transposed); // Dimensions match (2x3) return ))("fake")

Forum Discussion

Excel pads dynamic array output with #NV values

Resources