How can I create a Vlookup to certain columns of data in a closed workbook?

[HeatherA]

I currently have a master file with data and copy copy my master file over 17 other excel files to update them monthly. How can I create a Vlookup from each separate file to the columns of data that I need in the master file even when the master file is closed?

Thanks for the help.

 

[Fazza]

hi Heather.

Rather than asking for a VLOOKUP formula it might be better to explain what you want. There are several ways to work with a closed master file, best approach will depend on what you need to do.

Regards, Fazza