title: Something like a VLOOKUP
body: <p>I'm attempting to merge two lists of different objects where a specific field (employeeID) is equal to a specific field[0,0] in another list. My code looks like this: </p>
  
  <pre><code>int i = Users.Count() - 1;
  int i2 = oracleQuery.Count() - 1;
  for (int c = 0; c &lt;= i; c++)
  {
      for (int d = 0; d &lt;= i2; d++)
      {
          if (Users[c].getEmployeeID().ToString() == oracleQuery[d][0,0].ToString())
          {
              Users[c].setIDMStatus(oracleQuery[d][0,1].ToString());
          }
      }
  }
  </code></pre>
  
  <p>This works... but it doesn't seem efficient. Any suggestions for more efficient code that will ultimately lead to the Users list containing the new information from the oracleQuery list?</p>