vlookup - changes on source file

Maxime Vanwynsberghe

Hi,

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?

 

 

 

J. Craig Williams

Don't use LOOKUP, use INDEX(...,MATCH()) functionality. Column order or number of columns do not matter.

Craig