vlookup - changes on source file
I've noticed that when you insert a column in one of the source files all vlookups in other sheets will reference an incorrect cell.
Either it should be smart enough to know the change on the source and change it's formula or at least give us an indicator the reference changed so we can take actions to correct.
Any way to avoid this?
Help Article Resources
Check out the Formula Handbook template!