title: Excel: Finding the right match from matrix "scheme"
body: <p>I am trying to "match" values or patterns from one sheet to another. I got like "matrix scheme" (the first pic) where I am looking for a certain pattern which is labeled as " _ " and "1". If there is a match ("1"), I should color it in red, or green when no match (" _ "). But that part is easy. 
  As you can see there are 4 "cases" for now, and that is exactly what I want to have on another sheet (the second pic) as match. But I am getting only one match (from Column S ("XC0")) and empty spaces (" _ ") for others even if there is a match.</p>
  
  <p><a href="https://i.stack.imgur.com/Fdtjw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Fdtjw.jpg" alt="enter image description here"></a></p>
  
  <p>Here is my match table (on picture beneath) where I used this function:</p>
  
  <pre><code>=VLOOKUP($A10;_0528_matrix[#All];MATCH(A$10;_0528_matrix[#Headers];0);0)
  </code></pre>
  
  <p><strong>Index/Match</strong> also gave me the same results. These <strong>NA errors</strong> are fine for now, that's what I am gonna remove later.</p>
  
  <p><a href="https://i.stack.imgur.com/WbsPA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WbsPA.jpg" alt="enter image description here"></a></p>
  
  <p>Tried with this and still nothing... </p>
  
  <pre><code>=SUM(INDIRECT("_0528_matrix[" &amp; A2 &amp; "]"))
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/9ZDla.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9ZDla.jpg" alt="enter image description here"></a></p>