Forum Discussion
Solved
Referencing Dynamic External Worksheet Filename (VLOOKUP/INDIRECT)
Hi, I am currently using VLOOKUP to extract multiple details from my tracker, where the filename changes as I save it. Scenario: File name yesterday : Tracker Oct-31 File name today : Tracker ...
How about
=VLOOKUP(A2,INDIRECT("'[Tracker "&TEXT(TODAY(),"mmm-dd")&".xlsx]OLT'!$A:$C"),3,FALSE)
How about
=VLOOKUP(A2,INDIRECT("'[Tracker "&TEXT(TODAY(),"mmm-dd")&".xlsx]OLT'!$A:$C"),3,FALSE)