title: Excel - vlookup time, error #N/A
body: <p>On the <code>sheet2</code> I have the data:</p>
  
  <pre><code>1.1.2017 1:00:00    4
  1.1.2017 2:00:00    7
  1.1.2017 3:00:00    10
  </code></pre>
  
  <p>and that goes on for the rest of the year.</p>
  
  <p>On the <code>sheet1</code>, in cell A1 is the selected month. 
  Then in cell A2 is the formula:</p>
  
  <p><code>=DATE(2017,A1,1)+1/24</code></p>
  
  <p>In cell A3 is:</p>
  
  <p><code>=A2+1/24</code></p>
  
  <p>Formulas like in the cell A3 continue for the rest of the column A.</p>
  
  <p>But when I try to use <code>VLOOKUP</code>, </p>
  
  <p><code>=VLOOKUP(A2,Sheet2!$A$2:$B$8761,2,FALSE)</code></p>
  
  <p>I only get value for A2, for A3 and so on I get <code>#N/A</code>.</p>
  
  <p>Actually I have the same file for the year 2016., same formulas and it works correctly. I only changed the year and now it doesn't work.</p>