Patch row based on column

[JSnapp]

Beginners question.  I have a database with team member name as one column and then individual columns for each training class offered. I need to patch the table to show the course has been completed.  I have a dropdown that allows for the manager to select the course taken and the employee but I'm not sure how to write the patch function to only patch the records based on what was selected in the dropdowns. I have attached a screenshot of the table to clarify as best I can. 

[RandyHayes]

@JSnapp 

The question comes more from this...

If a course is selected and an employee selected, but yet there is no record in the list for the employee...what then?  Create the record?

If so, then your Patch formula would be:

Patch(yourList,
    {ID: LookUp(yourList, course=yourCourseDropdown.Selected.Value && Employee = employeeDropdown.Selected.Value, ID),
     Course: yourCourseSelection
    }
)

There are several "unknowns" from your post, so the above is a general concept - not verbatim. 

I hope this is helpful for you.

[JSnapp]

The issue with this it seems, is that I would need to redo how the database is structured. As the columns are just the course which they may have completed.  I need a way to look at the first column ( team member name ) based on the Team member selected in the dropdown. Then After it finds that member, search through the remaining column names for the course specified by the course_selected dropdown, and patch that record with an O.