Fix the #SPILL! error

What #SPILL! means

#SPILL! is an Excel-specific error that appears when a formula tries to output multiple values (a spill range) but one or more of the destination cells are not empty or are otherwise blocked. XLOOKUP returns #SPILL! when it is asked to return multiple columns or rows and the cells below or beside it are occupied.

Common causes

• A cell in the spill range contains data, a space character, or even a formula result — Excel cannot overwrite it, so the entire formula errors.
• The spill range overlaps a merged cell — merged cells block spilling entirely.
• The XLOOKUP is inside an Excel Table (ListObject) and the return_array spans multiple columns, which tables do not support for spill.
• Another spilled array formula already occupies part of the target spill range.
• The return_array returns a dynamic number of rows (e.g. referencing a whole column) and Excel cannot determine the spill range size.

Example fix

The fix here is environmental — clear the blocking cells in F2:G2 so the three-column return has room to spill. The formula itself is valid once the range is empty.

How to fix it

1. 1Click the XLOOKUP cell and look for the blue dashed border showing the intended spill range. Find and clear any blocking cell — even a space counts. Use Go To Special > Constants to locate invisible content.
2. 2Unmerge any merged cells in the spill range: Home > Merge & Center (toggle off) for affected cells.
3. 3If the formula is inside an Excel Table and returns multiple columns, move it outside the table or restructure to return one column at a time.
4. 4To explicitly reference a spill range that may be blocked, use the # operator on the source: =XLOOKUP(A2,D:D,E:E#) but also resolve the blocking cell first.
5. 5If the return_array references a full column and the size is unpredictable, constrain it to a fixed range (e.g. E2:E1000) so Excel can allocate the spill region.

Frequently asked