Hello,

I have a question about shifting vlookup references when adding new columns to the referenced table.

Ex: I have a master data table with all my data

I have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number. 

Original formula:

After the new column add:

As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31). 

How should I write it so it shifts and I can add/delete columns if ever needed? 

Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit.

Thanks in advance!

​Hello, I have a question about shifting vlookup references when adding new columns to the referenced table.Ex: I have a master data table with all my dataI have a few different tabs with vlookups to said data. If I add columns to the master table, my vlookup references shift the range properly (adds 1 more column) but not the column number.  Original formula:After the new column add: As you can see, it adds a new column to my range (AF to AG) but not the corresponding extra column (stays at 31). How should I write it so it shifts and I can add/delete columns if ever needed? Changing formulas manually is the absolute last resort as I have about 600 formulas that I would need to manually edit. Thanks in advance!  Read More

​