Hi All,

I am having issues applying a vlookup that references a separate workbook -
the thing is this workbook neds to remain closed and has a name change
daily, depending on the date.

I have tried a few things such as the following:

=VLOOKUP($E$2,INDIRECT('K:\[IMP Data "& TEXT(TODAY()-2, "yyyymmdd")
&".xls]Data'!$A$1:$AI$65536),5,FALSE)


and

=VLOOKUP($E$2,INDIRECT('K:\INDRECT([IMP Data "& TEXT(TODAY()-2, "yyyymmdd")
&".xls]Data'!)$A$1:$AI$65536),5,FALSE)

But they both meet with either #N/A or #REF!

Is anybody able to assist me with a way I can get the vlookup to consult the
closed workbook?

Thank you in advance for any assistance rendered.

Cheers,
Clint