Forum Discussion
Spill Error in Excel when using Table format.
Hi, I keep getting the #Spill Error when using the dynamic Xlookup function.This only happens when I use the Table format i.e.does not happen when I change the Table to a Range. I tried looking it ...
That's misunderstanding. What dynamic array function returns is called spill. In your case FILTER() returns some values into A2:A30, entire object is spill. You may reference it as =A2# and you can't edit values within the spill, e.g. cell A10.
If function can't return spill into the grid, it shows #SPILL! error with some explanation why spill can't be returned - "the cell we need to spill data into isn't blank"
Thank you for the clarification and your assistance.