title: Matching two values for multiple columns. i cant figure how to approach it
body: <p>i have 6 columns</p>
  
  <p>Grade,Date, ID number, Grade Old, date old and ID number</p>
  
  <p>I need the grade to look for value in grade old and also date old of the grade needs to be within 2 weeks of the date then the ID number is same.</p>
  
  <p>for example:</p>
  
  <p>if grade = A then it needs to look for A in Grade Old and also compare the dates, if the date old is 2 weeks of date then ID number stays the same.
  (There can be multiple Grades i.e. Grade old can have multiple entries as A, just need to pick the right one by comparing dates.)</p>
  
  <p>I have no idea how do i achieve this. I tried a few codes but in vain.</p>
  
  <p>Thank you for your time.  I appreciate your help.</p>