Hello,

In my formula to take the amount of total collection there is a file name
ExtractDatainvcoll_Servr_080718, identified by date 080718 means this is the
status as of 18 July 2008.

But for today Jul 31, 2008 I should change the formula to reflect the
correct Vlookup, to be the name of ExtractDatainvcoll_Servr_080731.

My question is how can we make it automatically ( instead of manually
changed) it will change from the last file name.

Below is my formula:


=IF(ISNA(VLOOKUP(A13,[ExtractDatainvcoll_Servr_080718.xls]Sheet1!$A$13:$H$600,8,FALSE)),0,VLOOKUP(A13,[ExtractDatainvcoll_Servr_080718.xls]Sheet1!$A$13:$H$600,8,FALSE))

Thanks in advance for any help.
--
H. Frank Situmorang