Compare/Match for columns in one sheet

[AniSaikia]

Hi All,
Greetings!!

I want to compare column A and column B with Column C and column D
Column A data should be compared to Column C and value of Column B with Column D and return which are not matching

<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}--></style>[TABLE="width: 348"]
<!--StartFragment--> <colgroup><col width="87" span="4" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 87"]APP 1 [/TD]
[TD="width: 87"]Values[/TD]
[TD="width: 87"] AAP2 [/TD]
[TD="width: 87"]Values[/TD]
[/TR]
[TR]
[TD]STAR[/TD]
[TD="align: right"]20[/TD]
[TD] STAR[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD="align: right"]10[/TD]
[TD] XYZ[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]XYZ[/TD]
[TD="align: right"]50[/TD]
[TD] PQR[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]ANI[/TD]
[TD="align: right"] 10 [/TD]
[TD] ANI[/TD]
[TD="align: right"]9[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


Thanks in advance!!

Kind Regards,
Ani

 

[bhos123]

=IFERROR(VLOOKUP(C2,A:B,2,0)=D2,FALSE) enter this formula in E2, the result will be TRUE if the D2 value of name in C2 matches with corresponding value(column B) of same name in column A, else it returns FALSE