Fix XLOOKUP #SPILL Error

Originally published at: How to Fix XLOOKUP #SPILL Error - Excelbuddy.com

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…