title: How can I find matching data in another worksheet and get a cell value?
body: <p>I have an Excel workbook with 2 worksheets. Let's call them "Item List" and "Item Master".</p>
  
  <p>In "Item List" I have 2 columns, B ("Code") and C ("Subcode"). It looks like this:</p>
  
  <pre><code> A    B    C
  ----------------
  100   AR
  110   AR
  120   NU
  130   AR
  </code></pre>
  
  <p>In "Item Master" I have similar columns, K ("Code") and L ("Subcode"). It looks like this:</p>
  
  <pre><code> E     K    L    
  ----------------
  xx   100   AR
  xx   100   AR
  xy   120   NU
  xc   120   AR
  xz   130   AR
  </code></pre>
  
  <p>In "Item List", I need to have column C show the value of "Item Master" column E, IF the values of B and C match the values of K and L. </p>
  
  <p>So if (Item List)A AND (Item List)B match (Item Master)K AND (Item Master)L, then (Item List)C = (Item Master)E</p>
  
  <p>If there are multiple matches, the search can stop after the first match and get the value of column E since it will be the same for all matches.</p>
  
  <p>How can this be done? </p>