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

Question

How do I fix REF! and SPILL! errors when creating VLOOKUP in excel? I deleted unwanted rows prior to performing the VLOOKUP.&nbsp; When I undo, I still get the errors.&nbsp; I have had success before, but not sure what the issue is now.&nbsp; Please help.

detlef_lewin · Answer

Reggie121020&nbsp;Without the workbook and more details use a search engine.https://www.google.com/search?q=How+do+I+fix+REF%21+errorshttps://www.google.com/search?q=How+do+I+fix+SPILL%21+errors&nbsp;

peterbartholomew1 · Answer

Reggie121020&nbsp;If you are getting unexpected #SPILL! errors, you have most likely just moved to 365.&nbsp; Learn about dynamic arrays and, ideally, give up VLOOKUP and replace it with XLOOKUP.

reggie121020 · Answer

Great info. Will give it a try. Thank youPeterBartholomew1&nbsp;

starrysky1988 · Answer

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])

Forum Discussion

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

4 Replies

Resources