title: Excel Index & Match using a Boolean OR with Wildcard
body: <p>Data:</p>
  <p>(Columns A and B)</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>A</th>
  <th>B</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Apples &amp; Dates</td>
  <td>£1.20</td>
  </tr>
  <tr>
  <td>Oranges</td>
  <td>£0.50</td>
  </tr>
  <tr>
  <td>Pears</td>
  <td>£3.55</td>
  </tr>
  <tr>
  <td>Melons</td>
  <td>£4.44</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to do index match on the first column to find cells that contain &quot;Apples&quot; OR &quot;Dates&quot;.</p>
  <p>When I try this:</p>
  <pre><code>=INDEX(A1:B3,MATCH(1,(A1:A3=&quot;*&quot;&amp;&quot;apples&quot;&amp;&quot;*&quot;)+(A1:A3=&quot;*&quot;&amp;&quot;dates&quot;&amp;&quot;*&quot;),0),2)
  </code></pre>
  <p>(I press ctrl-shift-enter to put it as an array) I still get the #N/A problem</p>
  <p>What am i missing? (I have tried Xlookup but gives the same problem. If i try and just put a single array in of <code>=(A1:A3=&quot;*&quot;&amp;&quot;apples&quot;&amp;&quot;*&quot;)</code> it still fails</p>