Link (closed)workbook to (open)workbook

Originally Posted by :) Sixthsense :)

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.

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