Adding new columns into a sheet that has vlookup formulas referencing it


If I am referencing a sheet in a vlookup command from another sheet and I add a column to the sheet that I am referencing and it is not at the end of the sheet but before the column I am using in my vlookup formula then it will push the column number out by 1. The vlookup then references the wrong column?

Is there any way around this apart from adding the column right at the end or changing my vlookup?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!