VLOOKUP REF Error – Causes and Solutions
VLOOKUP REF Error because one or more table_array column is deleted Deleting table_array column causes VLOOKUP REF error when the col_index_num value becomes greater than the number of columns in table_array. This error occurs when VLOOKUP formula has already written; then someone deletes one or more …