I have the following formula, its referencing an external workbook:-

=VLOOKUP(C3,'051206Cost Centre 1 .xls'!$D:$F,3,FALSE), the problem is the

prefix to the external workbook is a date and this changes every day (i.e.

the '051206' bit of the formula is the current day in yymmdd format).

Is there any way I type in a single formula that will dynamically refer to

the current days spreadsheet? I have tried the following but it returns an

error: - =VLOOKUP(C3,"'"&TEXT(TODAY(),"yymmdd")&"Cost Centre 1

..xls'!"&$D:$F,3,FALSE)

Any suggestions much appreciated.

Thanks

Brian

Co-op Bank

Manchester, England

## Bookmarks