Replacing values between xls files?

[h4x0rmx]

I have a file with some statistics on how agents at work performed. This file gets sent to all of them, but before we send it we change the names for a number, so that they don't know how the other agents are doing (avoiding comparisons).
People had been doing this manually, but it's getting really complex as the number of agents is increasing.
I know that this can be automatized, but I have no idea on how to do it. A simple formula with an IF statement wouldn't be sufficient.
Here's an example of the data.
The file that is to be modified to be sent to all the agents looks like this:

Please Login or Register  to view this content.

The file that has the numbers linked to every user looks like this:

Please Login or Register  to view this content.

I have to come up with a file that looks like this:

Please Login or Register  to view this content.

I could change the numbers for others, so if there's a way to use a hash function (MD5, or something like that) that would be helpful.

If you have any ideas or suggestions I will really appreciate it.
Also, please be as explicit as possible, I'm a beginner.

[arthurbr]

Hi and welcome to the board
I confess I know nothing about hash functions or MD5
But you can build your table easily using the VLOOKUP function

[zbor]

a.xlsx

Codes with names... notice that they must be sorted in asceding order

b.xlsx

This sheet pull data from previous

[h4x0rmx]

Thanks you guys!
I appreciate your help!