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 report that gets emailed to me to update some data and it gets emailed as a .CSV but I can also export it as a .xlsx, which updates faster. Is there a way to do this with a wildcard character or is it not possible?
2 Replies
- 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.
Not sure, but as far as I know, using a dynamic file type in lookups with a wildcard is not possible. However, you can use the Indirect function to dynamicaly change the file path of a source workbook in a Vlookup function across sheets and workbooks. Attached are some links that might be of some help to you.
How to Use the XLOOKUP Function in Microsoft Excel
Dynamically changing the file path of source workbook in VLOOKUP
All statements without guarantee.
