title: Excel VBA vlookup using Dates
body: <p>I am working with <strong>three sheets.</strong> Worksheet <strong>Start Page</strong> has dates from A4 to lastrow. I have a <strong>Fund trend sheet</strong>  with dates from A11 to last row. The vlookup is <strong>searching for Dates</strong> in the  Fund trend sheet based on the list of Dates in the start page sheet. The <strong>search table range</strong> in the Fund trend sheet is <strong>Range(A11:C11) to lastrow</strong>. When the date is found it <strong>offsets (3,0)</strong>, and that value is presented is <strong>sheet Acurred Expenses</strong> Range("C7").  This will <strong>loop till the lastrow</strong> in  sheet start page A4.  </p>
  
  <p>=VLOOKUP('Start page'!A4,'Fund Trend'!A11:C21,3,0)</p>
  
  <p>=VLOOKUP('Start page'!A5,'Fund Trend'!A12:C22,3,0)</p>
  
  <p>as code i have not been successful:</p>
  
  <pre><code>Sub equity() 
  
  Dim Nav_date As Date 
  
  Dim equity As Integer 
  
  Nav_date = Sheets("Start page").Range("A4") 
  
  equity = Application.WorksheetFunction.VLookup(Nav_date,_
   Worksheets("Fund Trend").Range("A11:C12"), 3, False) 
  
  Sheets("Acurred Expenses").Range("C7") = equity 
  
  End Sub
  </code></pre>