title: Conditional IF Statement in Excel, Change Other Cells According to Content
body: <p>I'm trying to make a revision timetable for myself on Excel.</p>
  
  <p>Let's say I'm doing four exams, A to D. Each exam has a certain number of "practice papers" that I have to do. Below is a demonstration table on Excel:</p>
  
  <pre><code>ExamName     NoOfPapers
  ExamA        4
  ExamB        5
  ExamC        7
  ExamD        1
  </code></pre>
  
  <p>There is another table, with two columns: MonthDate and the paper I want to practice on that da. So,</p>
  
  <pre><code> May         Paper?
   1
   2
   .
   .
   .
   29
  </code></pre>
  
  <p>I want to make it work so that if I put ExamA in the field under <code>Paper?</code>, it would automatically deduct 1 from the NoOfPapers of ExamA, to make it 3, so I make sure I'm not repeating the paper too many times.</p>
  
  <p>If I only had 17 papers, it would have been easy to do it manually. But unfortunately I have 99 papers to do (exactly 99 :P). </p>
  
  <p>How can I implement this on a cell as an IF statement (or any other possible way) on Microsoft Office Excel?</p>
  
  <p>Thank you! :) </p>