Forum Discussion
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 ...
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.