title: index match with wildcards and multiple criteria
body: <p>I have used <code>INDEX(MATCH())</code> formulas of this form before, but never with wildcards. Could anyone explain as two why adding in the <code>A2&amp;"*"</code> would return an error value? I have checked the data and there definitely should be a match. </p>
  
  <p>The formula is as below:</p>
  
  <pre><code>{=INDEX(I1:M1000,MATCH(1,(M1:M1000=Sheet3!B1)*(I1:I1000=A2&amp;"*"),0),2)}
  </code></pre>