mardi 31 mars 2020

Output only items from Column B to Column C when All 3 conditions are met in Column A

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.

utp

Aucun commentaire:

Enregistrer un commentaire