Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
am not sure if its a vlookup issue | Excel Discussion (Misc queries) | |||
vlookup issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions |