Forum Discussion
Can you use a dynamic file type in lookups
I would like to be able to link a different workbook for an XLOOKUP that is currently a .xlsx extension but I would like to be able to link it to a .CSV extension of the same file name. I have a repo...
This is possible with INDIRECT but it's not something I recommend because it requires the source workbook to be open. It's not dynamic but a better approach may be to update the data source through Data | Edit Links | Change Source.