Formula for look up and transfer information

HI,   I need a formula for the following. I have two sheets, one with a list of training courses in column a and in row 1 several job titles, i have then written YES in each corresponding cell wher...