IF formula

Occasional Visitor

Hello,

 

I’m an early Excel user. I’m looking to create a checklist with the formula – return Y in column D for a specific client from column A, if one of the Client’s customers is marked as Y in column C.

Can anyone help?

 

Joanna_Bladek_0-1612948668875.png

 

1 Reply

@Joanna_Bladek 

The formula in D2 could be:

=IF(COUNTIFS(A:A,A2,C:C,"Y"),
"Y",
0)