When you do not execute an array formula using Ctrl + Shift + Enter keys, the formula output is the #VALUE! error.