mercredi 12 décembre 2018

If 1 or both columns has word, then enter text

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