title: Using INDEX & MATCH or VLOOKUP twice and returning a third column
body: <p>I have tried all day long but unfortunately I am unable to come up with the correct formula.</p>
  
  <p>My columns have the respective information.</p>
  
  <p>COLUMN A - season_id</p>
  
  <p>COLUMN B - team_id</p>
  
  <p>COLUMN C - (<strong>this is where I intend to write up the formula</strong>)</p>
  
  <p>I have a separate table that contains 'games played' details. In this table, the columns contain the respective.</p>
  
  <p>COLUMN E - match_id</p>
  
  <p>COLUMN F - season_id</p>
  
  <p>COLUMN J - team_id</p>
  
  <p>Please note, the 'games played' table has many repeating instances, like a team playing 10 times or more, but for the first table there are no repeating instances. I want to insert my formula in the first table (COLUMN C) such that, if value of cell A1 matches COLUMN F <strong>AND</strong> value of cell B1 matches COLUMN J, then return the first occurrence from COLUMN E.</p>
  
  <p>I have tried using the below formula but with no luck. It displays results but they are not accurate and some display errors. My list is quite large.</p>
  
  <pre><code>=INDEX(E:E,IFERROR(MATCH(A1,F:F,0),MATCH(B1,J:J,0)))
  </code></pre>
  
  <p>Thank you.</p>