title: Index/Match with multiple possible answers?
body: <p>There's a question about how to return some info in Excel, <a href="https://stackoverflow.com/questions/31837544/countifs-for-vlookup">COUNTIFS for VLOOKUP</a>. from @THATNewbie.</p>
  
  <p>Here's a quick summary:</p>
  
  <p>They have this table:</p>
  
  <pre><code>Report Name        User Name      Report Category
  Report 1           John Smith     Sales
  Report 1           Jack Black     Sales
  Report 1           Connie Rae     Sales
  Report 1           Brain Bonds    Sales
  Report 2           John Smith     Sales
  Report 2           Connie Rae     Sales
  Report 3           Jack Black     Inventory
  </code></pre>
  
  <p>And they would like to return the "Report Name" based on User Name and Report Category. </p>
  
  <p>My first thought was just to use Index/Match (as an Array)...however, I realize that if I use "John Smith" and "Sales" to look up the Report Name, there's two possible outcomes: <code>Report 1</code> and <code>Report 2</code>.  Index/Match will always return <code>Report1</code> (or whatever comes first, going down that column).</p>
  
  <p>My question is: Is there a way to write the Index/Match formula to check if it's already found <code>Report1</code> and therefore to go to the next match (<code>Report2</code>)?</p>
  
  <p>Here's a <a href="https://i.imgur.com/QWJHKmQ.jpg" rel="nofollow noreferrer">screenshot</a> to help visualize. As you can see, the Index/Match correctly finds <code>Report1</code> in C12, but also in C13.  Can you have the formula "look above" and if it's the answer that it WOULD return, to skip that and look for the next?  Does that make sense?</p>