Forum Discussion
#SPILL Error in Excel
I have been working on an assignment and using the XLOOKUP function to try to get a result. No matter how many times I do it, I keep getting the same answer. I have re-entered in the information coun...
We could do with seeing the formula. The simplest application of XLOOKUP returns a scalar, not an array that could generate a #SPILL! error. So do you have an array or search values or are you trying to return a row from a 2D range? Have you written the formula within a Table? More information is needed.