Return Date from a column based on multiple criteria

[aberry0613]

Hello everyone!  I am trying to create the yellow highlighted date column in the Excel file attached (without the highlighted column, the file is my input)  that a task would be ready to work based on if the depended on task is completed.  The task redy to work date would be the depended on tasks closed date.  

So, the criteria would be if Task Dependency Has Been Met = True, then find the task from the Task Depends on Task column in the Task Title column and use the Task Closed Date as the Date Task Ready to Work. 

I am assuming this is a multi field or multi row formula tool, and I am not very good at those.

Thank you in advance for your help!

[echuong1 · Accepted solution]

You can simply do a join on the task title and the tasks depends on task.

If the task closed date it filled in, it will be entered as the date task ready to work date.