title: Multiple criteria index matching
body: <p>I have spent hours trying to work this out, found articles online but they don't appear to work.</p>
  
  <p>I have an excel document with data on two tabs and want the below formula to show me the team people are on if the dates and userid match on both forms called "Raised Source" &amp; "Sheet1"</p>
  
  <pre><code>{=INDEX(Sheet1!F:F,MATCH('Raised Source'!E:E&amp;'Raised Source'!F:F,Sheet1!A:A&amp;Sheet1!B:B,0))}
  </code></pre>
  
  <p>This throws out a #N/A error</p>
  
  <p>Help!!!</p>