This error occurs when the spill range for a spilled array formula or PivotTable range isn't blank. Select the cell containing the #SPILL! error to reveal a dashed border that indicates the intended spill range.

Jun 14, 2024 · Let’s look at some of the scenarios where you could get the #SPILL! issue and how to correct them. We are going to use the following dataset, which contains some items in column B, …

Mar 13, 2023 · The tutorial explains what may cause a #SPILL error in an INDEX MATCH, VLOOKUP, SUMIF and COUNTIF formulas and how you can efficiently resolve it.

Aug 19, 2019 · Your VLOOKUP formula may return a #SPILL error if you have used an entire column as the data range. Try working with a more definite range in the formula to remove the error.

Aug 30, 2024 · You’ll mostly see the #SPILL error in the dynamic Excel 365 as it produces dynamic arrays. More details into what the #SPILL error is, what causes it and how can this be fixed in Excel …

Dec 17, 2025 · The #SPILL! error is a common headache for many people using modern Excel. The good news, however, is that it's not a calculation failure—it's almost always a space issue. As a …

Apr 22, 2025 · Learn how to fix the #SPILL! error in Excel VLOOKUP. Discover causes and step-by-step solutions to resolve spill errors and ensure your formulas work perfectly.

Jan 13, 2025 · The #SPILL! error appears when Excel’s dynamic array formulas can’t output results due to blocked cells in their designated spill range. This common issue, introduced in Excel 2025, affects …

Mar 18, 2024 · Most likely you're using a function in VLOOKUP that returns an array, and you've not the space to display it. Or you're using VLOOKUP with an entire column e.g., A:A as criteria, which in …

Feb 21, 2024 · So you have a SPILL error in your Excel tables? In this quick article, let me show you 3 easy fixes to the problem.