When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

Spilling is the behavior when Excel formulas produce multiple results that are returned to the neighboring cells. Now, the range of the cells containing these values is called the spill range.