The #NOSPILL! error is Excel's way of saying that a modern array formula can't extend itself because there is a potential blockage in its way.
Identify your intended array range
If you select the cell with the #NOSPILL! error, Excel will automatically highlight the array's intended area. This will allow you to identify the blockage and remove it, or resize your array.