title: Is there an INNER JOIN in Excel?
body: <p>I am looking to do an inner join of two different tables in an excel spreadsheet based on matching column values. Here is an example:</p>
  
  <p><strong>Table A:</strong></p>
  
  <pre><code>TICKER
  AAPL
  AMZN
  FB
  MSFT
  TWLO
  </code></pre>
  
  <p><strong>Table B:</strong></p>
  
  <pre><code>TICKER      PRICE
  AAPL        100
  FB          200
  TSLA        300
  DIS         400
  </code></pre>
  
  <p>The inner join should return tickers and prices from Table B for which there are tickers in Table A:</p>
  
  <pre><code>TICKER    PRICE
  AAPL      100
  FB        200
  </code></pre>
  
  <p>I have tried <code>VLOOKUP</code> and <code>MATCH</code> but am unable to emulate the <code>INNER JOIN</code> function that exists in <code>SQL</code>. Hoping the StackOverflow community can provide some help :)</p>