How do I fix REF! and SPILL! errors when creating VLOOKUP in excel? I deleted unwanted rows prior to

[Reggie121020]

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.

[#2]

@Reggie121020 

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

[#3]

@Reggie121020 

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.

[#4]

Great info. Will give it a try. Thank you@Peter Bartholomew 

[#5]

You may add @ sign just infront of the function or formula to prevent auto spilling.
For e.g
=@Vlookup(lookup_value,table_array,col_index,[range_lookup])
=Vlookup(@lookup_value,table_array,col_index,[range_lookup])
=Vlookup(lookup_value,@table_array,col_index,[range_lookup])
=Vlookup(lookup_value,table_array,@col_index,[range_lookup])