Excel vLoopup to compare two sheets
I have a sheet with below dataCol A Col B
101 AAA
102 BBB
103 CCC
104 DDD
105 EEE
another sheet with below data
Col A Col B
101 AAA
103 CCC
105 EEE
Now i need to compare both columns from two sheets. If it matches with both column then return 'True' else 'False'. My result should be below
Col A Col B Result
101 AAA True
102 BBB False
103 CCC True
104 DDD False
105 EEE True
