F
Frank Situmorang
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.
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.