Consider normalizing these tables in future.

For now, Check if this works:

Update POTable

set Buyer = PO.Name

FROM POTable PO inner join BuyerTable BT

ON PO.Buyer = BT.Buyer