Repeat find and replace

I currently have two lists I am working with. One is a big mix of many different names, names which all need to be replaced.

I have another list which has all of these original names included in one column and the names which should replace those names in the column next to it.

Is the a way have excel repeat the find and replace all function for the 1000 names I have in the list, without my having to manually repeat it for each name. The list looks like this:

1 name1
2 name2
3 name3
4 name4
...

the other list is a mix of many names in each cell

cell 1: cell 2:

1,3,5,2 2,6,4,7

Thank you for your help.

Hi,
I'm not sure I understand your example, but it sounds like you should be using a VLOOKUP() function, or maybe a combination of =MATCH() and =INDEX() functions.

Rgds