Vlookup formula

Hello,

I'm using the following Vlookup formula:
=IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Inves tment Support\Dummies2Live\2010\May 10\[04052010.xls]Sheet1'!$A$4:$F$600,6,0)),"PRINT",0)

This is linked to another spreadsheet - in this case 04052010.xls. Next day I will need to check file 05052010.xls and so on. To make life easier for my colleagues I wanted to add a cell with date where they can input the date and this will change the date in the formula (i.e. from 04052010 to 05052010) How can I link this formula to let's say cell A1 where I want to insert date every day.
Thanks


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF GridView Sample To Insert, Update, and Delete Records
http://www.eggheadcafe.com/tutorials...ple-to-in.aspx

The closest thing to this would be to use the INDIRECT function, however...

INDIRECT can't be used with an external workbook reference. *sad face*


--
Best Regards,

Luke M
iv wrote in message ...
Hello,

I'm using the following Vlookup formula:
=IF(ISNA(VLOOKUP(A4,'S:\Operations\Bloomberg\Inves tment
Support\Dummies2Live\2010\May
10\[04052010.xls]Sheet1'!$A$4:$F$600,6,0)),"PRINT",0)

This is linked to another spreadsheet - in this case 04052010.xls. Next
day I will need to check file 05052010.xls and so on. To make life easier
for my colleagues I wanted to add a cell with date where they can input
the date and this will change the date in the formula (i.e. from 04052010
to 05052010) How can I link this formula to let's say cell A1 where I want
to insert date every day.
Thanks


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF GridView Sample To Insert, Update, and Delete Records
http://www.eggheadcafe.com/tutorials...ple-to-in.aspx