Compare 2 columns in 2 sheets and populate 3rd column in sheet 1 [Closed]

Report
Posts
1
Registration date
Wednesday May 17, 2017
Status
Member
Last seen
May 17, 2017
-
Hello,
I have following sheets. I want to populate Sheet 1 column B with value in columnB in sheet 2 where sheet 1 CA value matches with Sheet2 CA

Sheet 1
Columns A B
ab Text 2
bc
cd
ef Text 3
ze Text 4
xy Text1

Sheet 2
Columns A B
xy Text 1
ab Text 2
bc
ze Text 4
ef Text 3



Please can someone help?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!