Values to be renamed automatically

This appears to be a simple Vlookup.
Using your list of vessels, let's create an example. Enter 'HDS' in cell D1. Then, in cell D2, enter this formula...

Formula:

=vlookup(D1,$A$1:$B$101,2,false)

I have never used anything other than 'false' for the last option, but the other three parts to this tell the cell to look up what is in cell D1 (HDS) within the first column of the table from cells A1 to B101 (The '$' signs will just mean that when you copy and paste this formula to other cells, it will always look in these cells) and then return whatever is in the second column.

So, in this case, it would return 'HYUNDAI DRIVE'

I hope this helps in some way