Forum Discussion
How do I fix REF! and SPILL! errors when creating VLOOKUP in excel? I deleted unwanted rows prior to
How do I fix REF! and SPILL! errors when creating VLOOKUP in excel? I deleted unwanted rows prior to performing the VLOOKUP. When I undo, I still get the errors. I have had success before, but not ...
If you are getting unexpected #SPILL! errors, you have most likely just moved to 365. Learn about dynamic arrays and, ideally, give up VLOOKUP and replace it with XLOOKUP.
Great info. Will give it a try. Thank youPeterBartholomew1