VLOOKUP From a File That Gets Updated Everyday

[kpallen1]

Hi,

I've been looking for a solution to this for a while and haven't found a solution yet. Here's my situation....

Everyday I am sent an updated "Worksheet 1" (master) that I need to integrate it into "Worksheet 2" (secondary) which has more specific information on it. I can vlookup the information from the worksheet 1 to worksheet 2 very easily. The issue comes up the next day when I am sent a new worksheet 1 and I have to redo all of my formulas.

=IF(VLOOKUP($A7,'C:\Users\co-kallen1\Documents\[NC LTE Master_Construction Tracker 3-18-13 Updated.xlsx]Master Tracker'!$A$3:$EA$733,63,FALSE)="","",VLOOKUP($A7,'C:\Users\co-kallen1\Documents\[NC LTE Master_Construction Tracker 3-18-13 Updated.xlsx]Master Tracker'!$A$3:$EA$733,63,FALSE))

Is there anyway to get this file to update without redoing the formulas? Hopefully this makes some sense. Thanks in advance!

[FDibbins]

Hi and welcome to the forum

for a start off, as you are using 2010, you can shorten your formula to...

=IFerror(VLOOKUP($A7,'C:\Users\co-kallen1\Documents\[NC LTE Master_Construction Tracker 3-18-13 Updated.xlsx]Master Tracker'!$A$3:$EA$733,63,FALSE),"")

what do you need to change in that formula, for the next day?

[kpallen1]

Thanks for the warm welcome!

This morning I received the new tracker "NC LTE Master_Construction Tracker 3-19-13" which will need to replace the old one. So I believe this is what it would look like today....

=IFerror(VLOOKUP($A7,'C:\Users\co-kallen1\Documents\[NC LTE Master_Construction Tracker 3-19-13.xlsx]Master Tracker'!$A$3:$EA$733,63,FALSE),"")

This formula is repeated ~25 times throughout, referencing different col_index_num. I have been manually modifying the table array, but I feel like there is probably a more efficient way to do this. I tried changing the new file to the name of the table array in the formula but they all end up showing the #REF! error. Thanks for shortening the formula as well.