title: Multiple arrays within multiple arrays
body: <p>I have multiple lookup values that I am trying to match across multiple arrays. I would like to match one of those lookup values across several arrays within the same match but I keep getting "#VALUE" or "#N/A". 
  Current formula I try to use is below simplified for ease of reading.</p>
  
  <pre><code>=INDEX($I$2:$I$10,MATCH(A2&amp;B2&amp;C2,$D$2:$D$10&amp;OR($E$2:$E$10,$F$2:$F$10)&amp;$G$2:$G$10,0))
  </code></pre>
  
  <p>In this case, I am trying to match <code>B2</code> either in <code>$E$2:$E$10</code> or <code>$F$2:$F$10</code>. What am I doing wrong?</p>
  
  <p>Thanks in advance!</p>