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...
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.