Replace Values in a file from Mapping Sheet

Hi All,

I’m looking for an approach to generate a transformed file where column values will be replaced with Target values from a mapping sheet dynamically. So there will be two input files-1.Extract ,2.Mapping(sample below)

Extract:
BU VENDOR SITE
xx BU yy 101
pp BU yy 102

Mapping:

image

Expected output:
BU VENDOR SITE
US BU ABC Inc. 101
CA BU ABC Inc. 102

Any approach to achieve this dynamically will be very helpful. As the Columns names can change for Mapping & Extract files.