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!

Hi Buzzbee,

Thanks a lot!

Unfortunately it is not quite what i was looking for.

I would like these two files to interact. File "Test" is daily generated by a onsite report and is always in a similar format.

Therefore i would like to copy into the filed D2 a formula, which will identify the vessel code and set the value to vessel name.

Thanks a lot!

Hi Guys!

Would really appreciate your help!

Thank you!