Assuming that C4:C70 is either "PASS" or "fail", try this:

=IF(C2="Vacant",IF(COUNTIF(C4:C70,"fail"),"Fail","PASS"),C2)