Vlook up along with conditions

Hi Team,

i have a report in such a way that there are so many status against the same name along with dates. Status like in progress, dropped, enrolled, not completed, planned, completed..

Now in the second sheet i have the names and i am trying to get the final status against each names. if i am manually updating the final status i will do this - if there is a word called "Completed" against a name, the final staus is "Completed". If there is no word called "Completed" against the name in the entire sheet, the final status is "Not completed".

i also need the date if the final status is "Completed".

i am looking for formula that will give me the final status and the date.

Sample data is attached in which the 1st sheet is the report with different status and the 2 nd sheet is where i am trying to update the final status and date.

Kindly requesting to help.