Forum Discussion
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 vloo...
Hi, I would suggest to use INDEX/MATCH instead of Vlookup. You will be able to name the specific column you want and then independently whether there are added columns/rows, the correct value will be returned.
Please see attached a sample document with proposed solution.
Martin