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 countless times and can just not figure it out. I have also tried the VLOOKUP function. It says my spill range is not blank but I have no options to select obstructing cells or anything. I have the 365 Excel version. Any help?
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.
Which formula did you enter?
Could you attach a sample workbook, or make it available through Google Drive, Onedrive, Dropbox or similar?
