How to inner-join in Excel (eg. using VLOOKUP)
<p>Is there a way to inner join two different Excel spreadsheets using VLOOKUP?</p>

<p>In SQL, I would do it this way:</p>

<pre><code>SELECT id, name
FROM Sheet1
INNER JOIN Sheet2
ON Sheet1.id = Sheet2.id;
</code></pre>

<p>Sheet1:</p>

<pre><code>+----+------+
| ID | Name |
+----+------+
|  1 | A    |
|  2 | B    |
|  3 | C    |
|  4 | D    |
+----+------+
</code></pre>

<p>Sheet2:</p>

<pre><code>+----+-----+
| ID | Age |
+----+-----+
|  1 |  20 |
|  2 |  21 |
|  4 |  22 |
+----+-----+
</code></pre>

<p>And the result would be:</p>

<pre><code>+----+------+
| ID | Name |
+----+------+
|  1 | A    |
|  2 | B    |
|  4 | D    |
+----+------+
</code></pre>

<p>How can I do this in VLOOKUP? Or is there a better way to do this besides VLOOKUP?</p>

<p>Thanks.</p>