title: Excel - issue with VLOOKUP formula - it doesn't pick dates
body: <p>I need help with the below formula. I already tried to find a solution for this problem but no success.</p>
  
  <p>If account number exists in column A in the 'Returns' tab and also in column A in the 'July Sales' tab, then I need to get date from the column B in 'Returns' tab.</p>
  
  <p>I manually checked a few accounts on both spreadsheet and find some duplicates.</p>
  
  <p>My formula is as follows:</p>
  
  <pre><code>=VLOOKUP(Returns!A:B,A:B,2,0)
  </code></pre>
  
  <p>Screenshots:</p>
  
  <p><a href="https://i.stack.imgur.com/tvxok.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tvxok.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/vTjLk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vTjLk.png" alt="enter image description here"></a></p>
  
  <p>I tried to change format to text/general, text to columns and trim function but it's still not working.</p>
  
  <p>Also, as I have over 200k rows in each table, can I use any different formula instead to speed this up?</p>
  
  <p>Finally, is there any way to pick dates only if these are within 30 days</p>
  
  <p>Thanks in advance.</p>