Vlookup Query

[nickharr]

I have a Master sheet that has many columns of information on it and I use the Vlookup function to extract information from this Master sheet to feed various other sheets in different workbooks. Not sure if this is the best way of doing this but it works!
My problem is that I want to insert a new column in the Master sheet but if I do, I am then getting the wrong information in the other sheets as all the information in the Master sheet has been moved up one column.
Would there be a way to get over this problem? Any ideas would be gratefully received!

 

[kidwispa]

I have a Master sheet that has many columns of information on it and I use the Vlookup function to extract information from this Master sheet to feed various other sheets in different workbooks. Not sure if this is the best way of doing this but it works!
My problem is that I want to insert a new column in the Master sheet but if I do, I am then getting the wrong information in the other sheets as all the information in the Master sheet has been moved up one column.
Would there be a way to get over this problem? Any ideas would be gratefully received!

Could you not just add the column to the end of the sheet?

 

[nickharr]

It is possible that I could do that but I really want to put a column in between C and D as it is information that I am looking at all the time - if I put it right at the end - which would be column DT - its quite a way to get to it!

 

[kidwispa]

It is possible that I could do that but I really want to put a column in between C and D as it is information that I am looking at all the time - if I put it right at the end - which would be column DT - its quite a way to get to it!

The only way round i can think of (if you really want to insert between C and D) is to use find and replace to update all of your formula refs (ie replace $A$ with $B$ - don't include the row numbers then you can do the entire column at once)... bit of a long way round but will fix the issues you're having (until you next want to add a column that is! )