title: Match function in Excel returns N/A
body: <p>I have the following 3 columns in my excel sheet. The dates in column A (DateTime) are in the same format as column N(DateTime2) : </p>
  
  <p><strong>Example of Excel matrix</strong></p>
  
  <p><img src="https://i.stack.imgur.com/lhYNw.png" alt="Example of excel matrix"></p>
  
  <p>The data are a lot, so I can't check it one by one. I tried to use match command in order to identify which date from column N(DateTime2) exist in column A(DateTime). I used the following command: </p>
  
  <pre><code>=MATCH(N2;$A$2:$A$5849;0) 
  </code></pre>
  
  <p>I used autofill and as a result I got only first value as a number (which means that it exists), and the rest as N/A ..which is wrong. As you can see the value 1/1/16 3:00 exist in both columns. </p>
  
  <p>I tried then to use the function VLOOKUP and I wrote the following command: </p>
  
  <pre><code>=VLOOKUP(N2;$A$2:$A$5849;1;FALSE)
  </code></pre>
  
  <p>I got the same outcome.. I checked one random value <code>(1/1/16 3:00)</code> to check if the two cells with the same value are equal using the command : <code>=A3=N5</code> and I got TRUE ..which means that the two cells are matching. </p>
  
  <p>What do you think? What is the problem? </p>