Excel #SPILL! Error
A dynamic array cannot place all of its results.
LIKELY CAUSE
Why it happens
Clear blocked cells, merged cells or table restrictions around the spill range.
SAFE FIX
What to do
Select the error indicator to identify the blocking cell.
Debug in this order
- Reproduce the problem on the smallest sample that still fails.
- Inspect the exact keys, types, ranges or markup involved instead of only the displayed value.
- Fix the root cause, then rerun the original case and one known-good case.
- Document the rule if the same problem can return in recurring work.
Do not hide an unexplained data error with a cosmetic workaround. Make the input and matching logic predictable first.