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 see little benefit in hybridising list and array technologies (Table and Dynamic Arrays) but, if you are desperate to do that, you could look up terms of the dynamic array one by one to bring into the table.
= INDEX(filtered#, [@index])The dynamic array can either be a helper range or could be recalculated in its entirety, once for every row of the table.