Substitute parts of Entries by criteria list

Hello everybody!

I have a problem which I couldn't solve so far. I used the search function and google already but had no success.

Here the problem:

I have a list of filenames imported to Excel. The have the format "AMLF_716.jpg" for example.

Now I have another list with two coloumns that identify the three digits code (in coloumn 1(here f.e. 716)) with a name (in coloumn 2(here f.e. Blue).

As an output I need the new name AMLF~Blue.

I would get it done with substitute if I just have a single value to replace, but with a whole list of criteria it exceeds my Excel skills.

I hope one of you guys has an idea.

I really apprechiate your help!

Thanks,

Raph