=IFERROR(INDEX(Sheet1!B:B, MATCH(C4, Sheet1!A:A, 0)) = "Woman", FALSE)
=IFERROR(INDEX(Sheet1!B:B, MATCH(C4, Sheet1!A:A, 0)) = "Man", FALSE)
try this