I have a workbook with a VLookup formula to a closed workbook. It works most of the time.
But sometimes it returns #I/T in some rows. And it is not the same row from time to time. If I then open the closed workbook, then it works perfect.
Can someone please tell me what is wrong and maybe how to fix it?
Thank you in advance.