I have one worksheet which has certain information in and a seperate worksheet which has additional information in and i would like to extract one field from one and add it to the other

Each row has a unique reference number is on both sheets

So Sheet A looks like this for instance

A B C
1. Reference No. About me AdditionalInfo
2. 123456 this is
3. 567488 Help

Sheet B like this

A B
1. Reference No. AdditionalInfo
2. 567488 More info
3. 123456 Extract info

And basically for every row in Sheet A i want to refer to sheet B for that reference number, get the additional Info and then add it to the additional info cell in sheet A.

Can i do this without coding?