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 ?

	A	B	C	D	E
1	Customer	New		Customer	New
2	Cust A	New		Cust A	( New )
3	Cust A			Cust B	( New )
4	Cust B	New		Cust C
5	Cust A
6	Cust B
7	Cust C
8	Cust C

<tbody>
</tbody>

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.