=INDEX(Sheet1!B:B, MATCH(C4, Sheet1!A:A, 0)) = "Woman"
=INDEX(Sheet1!B:B, MATCH(C4, Sheet1!A:A, 0)) = "Man"
try this i am sure it will work