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>

APP 1	Values	AAP2	Values
STAR	20	STAR	20
ABC	10	XYZ	30
XYZ	50	PQR	20
ANI	10	ANI	9

<!--StartFragment--> <colgroup><col width="87" span="4" style="width:65pt"> </colgroup><tbody>
<!--EndFragment--></tbody>

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