Forum Discussion
rach1345
Jan 30, 2023Brass Contributor
spill error excel
Hi, Can anyone help please? I have tried vlookup but it is bringing up spill error and if bringing up #n/a. formula is to show which ones are 1 line deliveries (column J) then links the delivery ...
Riny_van_Eekelen
Jan 31, 2023Platinum Contributor
rach1345 Your file doesn't include the VLOOKUP formula you describe and thus doesn't show the SPILL error. But, the fact that you get a SPILL error means that your Excel version supports dynamic array functions. So, scrap VLOOKUP and start using XLOOKUP.
Having said that, SPILL indicates that the formula is trying to spill the result into multiple cells in one go. If that range of cells is not empty, Excel can't output the result and returns a SPILL error.