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 #...
I'm using the same logic i.e. xlookup to another table in another workbook using the cell range instead of table name and header name. Works like a charm.
So now the questions is, why does Microsoft not make it work using tablename and headername.