Tools Hub
1 The two files
File A

Material list

Part number + Unit

File B

BOM — Purchase Request

OEM Part Number + UOM

B sheet
Matched on part number. Headers are found automatically — column order can move.
2 Result
Drop both files to compare.