title: Excel VLOOKUP Increment
body: <p>I am creating a excel file that will pull a daily report from a folder on a different drive everyday. I was wondering if there is a way to increment a file name in the formula by 1 easily? </p>
  
  <p>The formula I am currently using is:</p>
  
  <pre><code>=VLOOKUP("Oil Production(Sm³)",'G:\DPNA\Non_Op_Assets\Hib\Pe\Production\Reports\Daily Report\2019\01 Jan19\[190113 Daily Report.xls]Daily Report'!$A$1:$P$500,3,FALSE)*1
  </code></pre>
  
  <p>I was wondering If it is possible to be able to get the 190113 to increment by one for the next 365 cells easily.</p>