User Profile
cgaechter
Copper Contributor
Joined Nov 16, 2023
User Widgets
Recent Discussions
VLOOKUP References to tables with new columns
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!
