Removing duplicates between two different excel sheets

[aabir]

I have two excel sheets A & B respectively each containing vendor data.

I want to check if excel B has duplicate data similar to excel A.The basis for differentiating will be the e-mail id column/field in both the excels which is unique.

e.g. If excel A has email ids aabir.bose@gmail.com,123@xyz.com,abc@def.com
and Excel B has email id 123@xyz.com then this email id(123@xyz) will be eliminated from excel B.
Finally only data with unique email ids which are not present in excel A will remain back in excel B.

Do I use VLOOKUP and if yes then how to frame the fromula??or is there some other way.

Thanks
Abir

 

[niladri2005]

apply Vlookup

=IF(VLOOKUP(B2,A!$A$2:$A$3,1,0)=$B2,"Match",""). for more please visit

Excel VLOOKUP Tutorial