title: How to inner-join in Excel (eg. using VLOOKUP)
body: <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>