Hello Everyone,
I have one file that has many Vlookup links to three other files.
Whenever I close the source files I get the following errors;
1. #N/A
2. #REF

Once the source files are reopen the values return.