I have two columns, one with account types (-A -B -C -D -E, etc) I only want Column B to be output into Column C if the account holder from Column B has all three account types (-A -B and -C)
Objective: Output Row from Column B into Column C IF Column A ends with -A, -B and -C
Here is what I have tried:
=IF(RegExMatch(A2:A,"-A") AND (RegExMatch(A2:A,"-B") AND (RegExMatch(A2:A,"-C"),"$ColumnB","No Output")
Clearly does not work and I am terrible with Google Sheets.
Aucun commentaire:
Enregistrer un commentaire