title: Excel - VLOOKUP vs. INDEX/MATCH - Which is better?
body: <p>I understand how to use each method: <code>VLOOKUP</code> (or <code>HLOOKUP</code>) vs. <code>INDEX</code>/<code>MATCH</code>.</p>
  
  <p>I'm looking for differences between them not in terms of personal preference, but primarily in the following areas:</p>
  
  <ol>
  <li><p>Is there something that one method can do that the other cannot?</p></li>
  <li><p>Which one is more efficient in general (or does it depend on the situation)?</p></li>
  <li><p>Any other advantages/disadvantages to using one method vs. the other</p></li>
  </ol>
  
  <p><strong>NOTE</strong>: I am answering my own question here but looking to see if anyone else has other insights I hadn't thought of.</p>