Take range of people and put some of them on a new sheet if they match a criteria?

[galileo007]

Is there a simple way to take a range of people and put them on a new sheet if they match a criteria in a different cell on the same row? I tried INDEX and MATCH but I don't want blank rows...

[galileo007]

Maybe I am using INDEX and MATCH wrong? I have =IF(ISNA(MATCH(ROSTER!C2&"YES",INDEX(ROSTER!$C$2:$C$436&ROSTER!$P$2:$P$436,0),0)),"",INDEX(ROSTER!B2:B$436&" "&ROSTER!C2:C$436&", "&ROSTER!D2:D$436,MATCH(ROSTER!D2&"YES",INDEX(ROSTER!$D$2:$D$436&ROSTER!$P$2:$P$436,0),0),0))