musicgold
06-17-2013, 06:13 AM
Hi,
I have an excel file – central database - that holds a lot of raw data organized in tables. There are more than 15 files (dependent files) that access this data using VLOOKUP formulas.
I now need to add a few columns to the central database and these columns can’t be after the columns already existing, i.e. they have to be on the left of some of the existing columns. As you may appreciate, inserting those columns is going to mess up all the vlookup formulas in the dependent files.
Is there a way change the central database file without affecting the vlookup formulas in the dependent files?
Thanks.
Cross posted here: http://www.mrexcel.com/forum/excel-questions/706982-vlookup-issue-how-change-source-file-table_array-without-affecting-vlookup-formulas.html#post3498083
I have an excel file – central database - that holds a lot of raw data organized in tables. There are more than 15 files (dependent files) that access this data using VLOOKUP formulas.
I now need to add a few columns to the central database and these columns can’t be after the columns already existing, i.e. they have to be on the left of some of the existing columns. As you may appreciate, inserting those columns is going to mess up all the vlookup formulas in the dependent files.
Is there a way change the central database file without affecting the vlookup formulas in the dependent files?
Thanks.
Cross posted here: http://www.mrexcel.com/forum/excel-questions/706982-vlookup-issue-how-change-source-file-table_array-without-affecting-vlookup-formulas.html#post3498083