title: Track task dependencies in Excel
body: <p>I have two tabs in my excel sheet.</p>
  
  <p><strong>Tab 1</strong>: Contains a list of all the dependencies across multiple functional area. The columns are functional area, dependency description, dependency id, plan end date, target end date.</p>
  
  <p><strong>Tab 2</strong>: Contains a list of tasks with the following columns: </p>
  
  <p>Functional area, Deliverable name, deliverable description, Target Date, projected date, Dependencies ID</p>
  
  <p>E.g.</p>
  
  <pre><code>Functional Area Dependencies  Plan end date  Target End date
     F1            D1            8/22           8/22
     F1            D2            8/23           8/23
     F2            D3            8/24           8/24
     F2            D4            8/25           8/25
  
  Functional Area Deliverable Dependencies Target Date  Projected Date
     F1                de1       D1, D2        8/20           
     F1                de2       D1            8/20           
     F2                de3       D3, D4        8/20           
     F2                de4       D3            8/20           
  </code></pre>
  
  <p>The Dependencies ID will contain all the IDs tied to a given deliverable from tab 1. The help I want is a way to find out that if any of my dependencies tied to a given deliverable have a date past the targeted date of my deliverable, my projected date should be populated to the latest date among all the dependencies. So in the above example, projected date for de1 should be populated to 8/23 and projected date for d2 should be 8/22. Please advise. Thank you.</p>