I have to compare 2 sheets, which has around 1 lakh data. Two sheets ( A & B) A has two columns A1 and A2. B has two columns B1 and B2. In my case Some of the value in A and B1 are same, for such cases I want to update B2 = A2. So A2 should take the ...