Mar 17 2022 09:32 AM
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 sure what the issue is now. Please help.
Mar 17 2022 10:15 AM
Without the workbook and more details use a search engine.
https://www.google.com/search?q=How+do+I+fix+REF%21+errors
https://www.google.com/search?q=How+do+I+fix+SPILL%21+errors
Mar 17 2022 10:29 AM
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.
Mar 18 2022 01:45 AM