Fix XLOOKUP #SPILL Error

Learn to easily fix an XLOOKUP #SPILL Error in Excel. Chances are if you have been working with Dynamic Array Formulas in Excel, you have run across a Spill Error. Basically, this error occurs when the spill range is blocked.

Look at the example below. Here you can see that when the XLOOKUP formula is copied down using the fill handle, it returns a Spill error.

Fix XLOOKUP Spill Error
Fix XLOOKUP #SPILL Error

One simple way to fix this error is by adding an “@” before the formula.

=@XLOOKUP(value,range1,range2)

By adding the “@” sign before the formula, Excel will enable Implicit Intersection which many value are limited to a single result. This prevents Excel from showing the #SPILL Error message.

XLOOKUP Horizontal Lookup Spill Error Fix
Add “@” before the formula

Leave a Reply

CONCAT Function

The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016

Read More »

VBA ColorIndex

Colors Colors could be very important and useful in excel application. There are two ways in which you can get

Read More »
Scroll to Top