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?