title: Index Match Array formula not working properly
body: <p>I am completely stumped with an array formula that will not work. I have researched and tried many different things and continue to get the #N/A error. I am hoping someone here can help me understand.</p>
  
  <p>I have a database of employee skills in a table named "Skills" with three columns. Employee ID, Type and Skill <a href="https://i.stack.imgur.com/gbblz.png" rel="nofollow noreferrer">Picture of table</a></p>
  
  <p>On another tab I am trying to run an Index Match array to filter employees that have certain skills. I would like to be able to use 1 or more criteria. For example employees that have the skill "Infor" and "syspro" The criteria is in cell A2 and C2</p>
  
  <p>I am attempting to use the following formulas to do this and they are not working. And I am pressing ctrl+shift+enter</p>
  
  <pre><code>=INDEX(Skills[Employee ID],MATCH(1,($A$2=Skills[Skill]),0),1)
  =INDEX(Skills[Employee ID],MATCH(1,($A$2=Skills[Skill])*($C$2=Skills[Skill]),0),1)
  </code></pre>