index match with wildcards and multiple criteria
<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>