Forum Discussion

Copper Contributor

Mar 17, 2022

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

Formulas and Functions

Starrysky1988

Iron Contributor

Mar 18, 2022

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