C
Clinton M James
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
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