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