title: Vlookup to search non-unique values
body: <p>I have 2 excel sheets with below values</p>
  
  <p>Sheet1</p>
  
  <pre><code>EmpID AppName AppID [Only AppID is Unique]
  </code></pre>
  
  <p>Sheet2</p>
  
  <pre><code>EmpID AppName RequestNum [Only RequestNum is unique]
  </code></pre>
  
  <p><code>EmpID</code> is repeated since there are multiple apps associated with one users
  AppName is repeated since there are multiple instances of single app associated to one users</p>
  
  <p>Now, I want to get RequestNum from <code>Sheet2 into Sheet1</code>, but it obviously returns me the 1st value in case of duplicates. Concatnating <code>EmpID &amp; AppName</code> does not work since it does not make a unique combination. How do I achieve that? Would it be possible with combination of formulae or do I need a macro?</p>
  
  <p>Pasting the sample for my sheets below:</p>
  
  <p><strong>Sheet1:</strong></p>
  
  <pre><code>EmpID   AppName AppID
  A123    App1    UniqueID001
  A123    App2    UniqueID002
  B444    App66   UniqueID003
  B898    App1    UniqueID004
  H123    App33   UniqueID005
  A123    App1    UniqueID006
  B444    App33   UniqueID007
  L001    App2    UniqueID008
  H123    App1    UniqueID009
  </code></pre>
  
  <p><strong>Sheet2</strong>:</p>
  
  <pre><code>EmpID   AppName RequestNum
  A123    App1    UniqueReq001
  A123    App2    UniqueReq002
  B444    App66   UniqueReq003
  B898    App1    UniqueReq004
  H123    App33   UniqueReq005
  A123    App1    UniqueReq006
  B444    App33   UniqueReq007
  L001    App2    UniqueReq008
  H123    App1    UniqueReq009
  A123    App1    UniqueReq010
  A123    App2    UniqueReq011
  B444    App66   UniqueReq012
  B898    App1    UniqueReq013
  H123    App33   UniqueReq014
  A123    App1    UniqueReq015
  B444    App33   UniqueReq016
  L001    App2    UniqueReq017
  H123    App1    UniqueReq018
  </code></pre>