Okay, I have a column that has text in it. I want to change all these to the
Identifying number that is found in a different table. So how do I do this?
Example:
Current table has:
A
1 First name
2 New first name
3 Another first name

Need to change the A column in first table to the correspoding column in
this table:
A B
1 12 First name
2 15 New first name
3 22 Another first name

So after the switch either I need a new column in the current table so it
look like the second column (there might be more then one match in the
current table to the numbers in the 2nd table) Or just totally replace
anything that matches Column B in to Column A. Does that make sense?

So after combining current table should be:
A
1 12
2 15
3 22

Thanks for any help!