If Match , Check the value in another column and return Yes.

[Velven]

Hello Guys !

Here's what I'm trying to do.

Column A is my customers record.
Column B indicates whether the customer is New or not.
Column D is my Unique customer extracted List.

Reason why I did not put Cust C as he's not a new customer.
What formula should I input in Column E to return a "New" if D matches A and B lists as New ?
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Customer[/TD]
[TD]New[/TD]
[TD][/TD]
[TD]Customer[/TD]
[TD]New[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Cust A[/TD]
[TD]New[/TD]
[TD][/TD]
[TD]Cust A[/TD]
[TD]( New )[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Cust A[/TD]
[TD][/TD]
[TD][/TD]
[TD]Cust B[/TD]
[TD]( New )[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Cust B[/TD]
[TD]New[/TD]
[TD][/TD]
[TD]Cust C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Cust A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Cust B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Cust C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Cust C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks once again.
For some reason I've been brain dead today

Vel

 

[Marcelo Branco]

Try

E2 copied down
=IF(COUNTIFS(A:A,D2,B:B,"New"),"New","")

M.

 

[Velven]

Thanks M !

Arh there's the countifs as well !

Thanks a lot. It's a great help !

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.