Did they complete their training? (Need a formula)

Hi,

So we have these individuals (Approx. 2000 employees & I would like to know )

Based on the training matrix have they completed their courses ..... Y/N ( I prefer to have the date when they completed their course).

Thanks for all the help