Find and Replace or Other tool

[Drexler]

Good day, newbie here

I have 2 files, 1 file has columns A and B while file 2 has column A only. Both data of columns  A (file 1 and 2) are the same. I need to transfer the equivalent data of file 1 column B to file 2 column B if both columns A for 2 files are match. What's the best solution/tool for this scenario

See sample data below. Thank you Everyone

 

[joelmiller66]

@Drexler I believe you can use a Join Tool or a Find & Replace Tool. Attached are sample workflows.