Generate list based on multiple criteria - list active projects by engineer

Try:

Formula:

{=IFERROR(INDEX($F$1:$F$60,SMALL(IF((ISNUMBER(SEARCH($K$2,$I$1:$I$60)))*

(($B$1:$B$60="Design")+($B$1:$B$60="Quoting")+($B$1:$B$60="Feasibility")+($B$1:$B$60="Post Design")),(ROW($F$1:$F$60))),ROW(1:1)),1),"")}