VLOOKUP and date issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to setup a formula like this.
=VLOOKUP(AA8,[filename_20070725.xls]base'!$A$1:$CJ$302,12,).
Everyday a new file is created with the date appended to it. And instead of
manually changing the filename in the formula everyday I would like to
somehow have the formula automatically increment the date by 1 everyday.

For example, if today is 7/26/07, then the formula should be:
=VLOOKUP(AA8,[filename_20070726.xls]base'!$A$1:$CJ$302,12,).

Any help is welcome. Thanks.
 
Think you could try something like this, using INDIRECT and TEXT:
=VLOOKUP(A1,INDIRECT("[Book1_"&TEXT(TODAY(),"yyyymmdd")&".xls]base!$L:$M"),2,0)

TODAY() within the TEXT(...) part of it will provide the required daily
incrementation of the date.
 
Back
Top