title: Index + Match with multiple criteria and merged cells
body: <p>I have this fabulous excel workbook where I have some product data which we get from databases. I have four magnificent variables I put in. Year, Quarter, Week and Products.</p>
  
  <p>Im trying to do a index + match lookup for quantity sold but I only receive error #N/A. But I should get 1967 since thats what we sold. We didn't sold NA.</p>
  
  <p><img src="https://i.stack.imgur.com/waowq.png" alt="My Excel Workbook Problem"></p>
  
  <p>I'm using the this formula in E6.</p>
  
  <pre><code>=INDEX(C12:AH15;MATCH(1;($C$9=C9:AH9)*($E$3=C10:AH10)*($E$4=C11:AH11)*($E$5=B12:B15);0))
  </code></pre>
  
  <p>Is it possible to fix this formula to recieve the correct value, is merged cells problem?</p>
  
  <p><strong>EDIT:</strong> 
  After good suggestion I put values in every cell, not glamorous as before, but formula will still not detect the correct value.. any ideas what could cause the problem now? It shouldn't be the merged cells at least.</p>
  
  <p><a href="https://i.stack.imgur.com/9tWtl.png" rel="nofollow noreferrer">My revised workbook</a></p>
  
  <p>A lot of thanks in advance!</p>