Returning name list based on 2 criteria

Good afternoon everyone,

I'm working on an Excel template that has to return a list of employee names matching two criteria from information housed on a table.. The idea that I had was for a user to select a job function from a drop down and then have the formula A) Find the job function from the table, B) Find all instances of "Yes" under the job function and then C) Display the employee name(s) if true.

I was trying to use a combination of Index and Small to return the data, but, haven't had much luck with expanding it from this format (below) to return instances of "Yes"
{=INDEX($A$2:$F$15,SMALL(IF($C$3:$F$15=$B$18,ROW($A$3:$A$15)),ROW(1:1))-2,1)}

Any assistance would be much appreciated, I've attached a sample excel file to illustrate

That worked! Thanks for the assistance ChemistB