Forum Discussion
XLOOKUP link to another workbook doesn't work if workbook closed
Hello, I have an XLOOKUP in one worksheet that is pulling data from a reference table in a separate workbook. The lookup works fine if the reference workbook is open, but if it is closed, I get a #...
This has its limitations but it works. Look at the comment of the user "Fluff".
https://www.mrexcel.com/board/threads/xlookup-and-closed-workbooks.1157123/post-5611713