Matching data 2 cells in 2 sheets

[Christopherdj]

Hi
is it possible to provide a formula to match as per the uploaded file.
Data in Sheet one columns A and B, compared to what is in Sheet two column A
I have a lot of data, and only need a Y for yes, and N for No as a result.
thanks

[:) Sixthsense :)]

In C2 Cell of One Sheet

=IF(COUNTIFS(TWO!A:A,A2,TWO!B:B,B2),"Y","N")

Drag it down...

[samba_ravi]

=IFERROR(IF(VLOOKUP(A2,TWO!A$2:B$7,2,0)=B2,"Y","N"),"N")
Try this

[manishk16]

Hi Christopherdj,

Please use this

=IF(AND(ISNA(VLOOKUP(A2,TWO!$A:$A,1,0))=FALSE,ISNA(VLOOKUP(B2,TWO!B:B,1,0))=FALSE),"Yes","No")