I have started using XLOOKUP a lot as it for the myriad of reasons given in videos as well as it is easier to explain to my boss how I am handling errors.
However, sometimes I get #REF! errors when the formulas are looking into closed workbooks.
This is not a consistent error, so I cannot say exactly when it happens.
Is this a known "Feature?"
However, sometimes I get #REF! errors when the formulas are looking into closed workbooks.
This is not a consistent error, so I cannot say exactly when it happens.
Is this a known "Feature?"