Forum Discussion
mayakannanr
Nov 22, 2023Copper Contributor
spill error in excel vlook formula
how to resolve the spill error in excel vlook formula
Riny_van_Eekelen
Nov 25, 2023Platinum Contributor
mayakannanr How exactly have you constructed your VLOOKUP formula? In some cases you can only fix it by correcting the formula. In other cases you need to make sure that there is space for Excel to spill the results ( as suggested by rachel ).
And since you get the SPILL error it means you are using a modern Excel version. Perhaps better to acquaint yourself with XLOOKUP.
No need for an update, using Ctrl-Shift-Enter or any of the other suggestions by Saima14. I suspect that they come directly from an AI robot. As such, they are neither relevant nor meaningful.