title: excel vba - multiple criteria index match
body: <p>I'm trying to do a multiple criteria index match function in vba but I can't seem to get the results.
  The code I used is the following:</p>
  
  <pre><code>  wsDest.Range(wsDest.Cells(i, X), wsDest.Cells(i, X)) = _
    Application.WorksheetFunction.Index(wsSour.Range("C3:C8763"), _
      Application.WorksheetFunction.Match(wsDest.Cells(i, 1) &amp; "&amp;" &amp; wsDest.Cells(i, 2), _
        wsSour.Range("A3:A8763") &amp; "&amp;" &amp; wsSour.Range("B3:B8763"), 0), 0)
  </code></pre>
  
  <p>For the match portion I was trying to use excel's method of </p>
  
  <p><code>=MATCH(criteria1 &amp; criteria2,range1 &amp; range2,0)
  </code></p>