VLOOKUP and date issue
 

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.

VLOOKUP and date issue
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rumkey" wrote:
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.