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 ...
I use array formulas retrieving data from Excel Tables frequently (ever since gaining access to the Dynamic Array functions).
My experience with the SPILL error is that it occurs when some cell or cells are occupied with data and in the way of the results of the array function spilling out to its fllest extent.
Are you using the formula IN the table itself? I can imagine that wouldn't work; never occurred to me to try it. They're excellent when retrieving data FROM an Excel Table.
So maybe you could clarify exactly what you're doing and wanting to do....