Vlookup returns N/A despite of existing match
<p>I have two tables, <code>table1</code> and <code>table2</code>. I execute <code>VLOOKUP</code> function in order to fill in 3 columns from <code>table2</code> into <code>table1</code>.</p>

<p>For some reason, the formula doesn't work for the first row, and doesn't find the exact match from <code>table2</code> even though it exists.</p>

<p>I made sure that both columns (for comparison) have the same format (<code>General</code>) and there is no extra spacing. Same conditions also apply for the rest of the records, and it works there properly.</p>

<p><strong>table1</strong> - you can see the missing matches for the first row.
<img src="https://i.stack.imgur.com/2WXR8.png" alt="table1"></p>

<p><strong>table2</strong> - you can see the match does exist, but it is not reflected in <code>table1</code>.
<img src="https://i.stack.imgur.com/GHTiP.png" alt="table2"></p>

<p>Is there any other reason why <code>VLOOKUP</code> can't find a match for a specific record?</p>