Afternoon fellow excel users,

I need some help here. Basically on the 'Course' worksheet I have a list of employees & and there numbers where all I have to do is input a date for their course manually (nothing hard).

course.JPG

However....
On the 'Roster' worksheet I need the word 'Course' automatically placed in the cell after it finds the employee and the date matched in the Course worksheet.

Roster.JPG

Any ideas?? I'm struggling

Thanks Matt