Sorry for not paying proper attention in your formula and not seen your files also.
Without seeing your file the Vlookup formula is referring to TABLE REFERENCES and which requires the source workbook to be kept open.
Convert the TABLE REFERENCES to a normal excel RANGE REFERENCE to get rid of this issue.
Replying from mobile device.
Last edited by :) Sixthsense :); 07-24-2014 at 12:43 PM.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Originally Posted by :) Sixthsense :)
Thank you very much for this it had been bothering me for days and I never even thought about that
This issue is now resolved, thanks to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks