I am trying to create a formula that states: If either or both columns R & S on sheet 'Jan' have "fail" than enter a Y in column K of sheet 'Feb'. there are 4 possible outcomes: - Fail, Fail - Fail, Blank - Blank, Fail - Blank, Blank I have tried several formulas, but I cannot get it to recognize all 4 scenarios.
=IF(INDEX(Jan!R:R&Jan!S:S,MATCH(A3,Jan!A:A,0),1)="fail","Y","") was the closest I've gotten, but it did not insert a "Y" if both cells had "fail"
What am I missing? :(
Aucun commentaire:
Enregistrer un commentaire