Forum Discussion

JamesPhImp's avatar
JamesPhImp
Copper Contributor
Jul 26, 2023

Vlookup from a closed workbook where the filename changes with the date.

Hi, I have a vlookup: =VLOOKUP(C$1,'https://abcdef.sharepoint.com/sites/ABC/Shared Documents/ABC/Daily Process/CFF/FX Rates/[230710 FX RATES.xlsx]FX rates'!$A$1:$N$452,2,FALSE) Every day I need top...
excel
Formulas and Functions
Macros and VBA
Patrick2788's avatar
Patrick2788
Silver Contributor
Jul 26, 2023
It's do-able with INDIRECT but not recommended because the function requires the source workbook be open.

Resources