Thanks for replying NBVC. I put in the formula and it returns the first instance of the employee name/course title but not the training that is scheduled. Is there a way to tell it to check all criteria? ie: =IF(AND(AX24="C",AY24="C",AZ24="C"),M24,"")