FerJo,

Thank you very much for the deliverable day per phase calculations! They are very effective. I believe I left out something though. The way I have the roles set up in the first sheet(Deliverables) compared to the second sheet (new_Deliverable Summary), they follow a perfect order. Role 1 - 5.

In my first sheet (Deliverables), I do not get the benefit of this set up, for instance, my roles could be listed like so... Role 2 | Role 3 | Role 1 | Role 5 | Role 4


Is there a way to set this offset calculation to dynamically lookup these roles and then match them with their respective role fee?


Thanks,
Channing