This could be done via Data Blending.
For intro videos, please look here:
Please find the attached wb.
Hope it could help.
Please take into account that one should have
an exact match (case-sensitive strings) between
values in the fields to blend. That's why I use UPPER().