What I will fill in D is , If B1 = No , Match A1 with C:C If Match is true , Return Yes , otherwise No . ( Drag down to copy )
Is there any better formula or how do I put it together ?
<tbody>
A
B
C
D
1
John@John.com
No
Cast@cast.com
2
michael@michael.com
No
Rum@rum.com
3
R@R.com...