Replace alphanumeric code in Matrix with Volunteer Names

I am hoping somebody can help me with the following.

I have an Excel 2016 file that has two tabs/worksheets. On the first worksheet is a long list of volunteer names (column B) with an alphanumeric code in column "A" preceding their name. For example, A1, A2, A3, .... K1, K2, K3, etc...

On the other worksheet is a matrix that has the days of the week as the column headings and specific tasks as the row headings. Instead of typing names in each cell within the matrix, I have typed in the an alphanumeric code as mentioned above. Because this matrix is quite large, an alphanumeric code such as "A1" will appear multiple times.

So my goal is to have the matrix filled-out with all these alphanumeric codes and then somehow, via a macro or something, change all the alphanumeric codes to the associated name. It is important that I see the matrix filled-out with the alphanumeric codes first, and then have the ability to convert to the names. Any assistance provided would be greatly appreciated. Thank you for your time.

It is looks like possible to sort with VLOOKUP.
Can you attached samples file, please?
Put some mock data and expected results in there.

Into D20:

Please Login or Register  to view this content.

and drag it right and down as needed.

Check in attached file that everything has been assigned correctly.

Originally Posted by MickG

Try this:-

Why:
Capture.JPG
if B1 is Jones1
Capture2.JPG

Originally Posted by MickG

Why ???
Because there is no "Doe1" in sheet 1, I imagined this was a data error, and just used the data on sheet1.

Sorry, I did not spot that you have replace in top table. As you said expected results have been incorrect.
As OP said he wants to see codes and names so I've used VLOOKUP for bottom table and codes are still visible in top and names at bottom.

MickG: I have been using the spreadsheet you were kind enough to send me and it has been extremely helpful. I did run into a minor issue. I selected the button that changed "names to range" and saved the file and close excel. I then went back in to make a modification and selected the "return names to alphanumeric" and it didn't work. Any idea how to fix this? Thanks again for your help.

Here is another macro that you can consider...

Please Login or Register  to view this content.

Crew696
I'll have a look !!!!
Try this instead of the second code for returning !!

Please Login or Register  to view this content.

Regards Mick