Values to be renamed automatically

Hi Guys,

I have an excel sheet I have to manually adjust daily and it is very time costing.

Inside the company we have special codes for vessels and same for locations. I need to send the file to agents in the port who don't have a clue about the codes and i need to manually rename them.

I have created a "database" of vessel names and the codes (attached called "Macro"). I would like the formula to identify the vessel name and change it to a code and vise versa.

I have attached a file "test" where i have already manually changed the codes to the actual vessel name.

I would like to copy the formula to each report i create and use the file "Macro" as an database where i will be adding more vessels and locations.

Thanks in advance!