title: Excel Index and Match Function to verify data
body: <p>I have 2 spreadsheets of user data from 2 different systems.
  I want to use a combination of conditions. I want to look for matches that contain 2 of the 3 conditions but it must include the C2 condition regardless.
  So Ideally something like ...Match(A2&amp;C2 OR B2&amp;C2,'Old System'!A:A&amp;'Old System'!B:B&amp;'Old System'!I:I,0)),&quot;&quot;)</p>
  <p>This is the formula I am currently using but I have noticed it looks for matches of all 3 conditions rather than what I'm looking for.</p>
  <p><strong>=IFERROR(INDEX('Old System'!K:K,MATCH(A2&amp;B2&amp;C2,'Old System'!A:A&amp;'Old System'!B:B&amp;'Old System'!I:I,0)),&quot;&quot;)</strong></p>
  <p>Just for context, here are the matching columns between the two systems</p>
  <p>Old System K - $ amount paying in old system, New System A -&gt; Old System A - User ID, New System B -&gt; Old System B - Name, New System C -&gt; Old System I - Payment Group Name</p>