Replicate Vlookup Function in Tableau
Create two sheets in Excel. One for your data, and one for your lookup table.
Connect to your excel datasource.
Drag in your data table, then click the dropdown to open the physical table.
Drag in your lookup table, and left join on [Region] = [Region]