title: Index Match multiple criteria with one OR condition
body: <p>I have the following <code>index</code> <code>match</code>formula:</p>
  
  <pre><code>=IFERROR(INDEX($B:$B;(MATCH(1;($C:$C="Value1")*($D:$D=$F3)*($E:$E=OR("X";"Y";"Z"));0)));"")
  </code></pre>
  
  <p>however, I want <code>$E:$E=OR("X";"Y";"Z")</code> to be one of the conditions of the <code>match</code>: I want to see if <strong>E</strong> has one of these three values. 
  Currently it gives an error. How to achieve this condition in the match statement?
  Thanks</p>