Hello, hoping someone can help me

I am trying to build a training tracker, the raw data exported from our web ePk website has the following columns:

Employee ID, Employee Name, Course Name

A row is only populated with completed courses, if a course has not been done you don't get a row with that person's name and ID on that possible course in the download. Here is what I need to do:

Each employee will have their own page in the excel sheet and it will have the following columns, all the possible course names will be under the course name column.

Course Name, Complete?

I need to populate a "YES" in the "Complete?" column by looking at the downloaded sheet and if on the same row employee # "1234" = employee #"1234" in the download sheet AND Course Name = Course Name in the download sheet.

Basically an IF statement that looks for two criteria that must be on the same row to be true. Is this possible?