Replace data in a column

[Amelia]

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!

 

[Jacob Skaria]

Suppose you have the first table in Sheet1 ColA and your data table with 2
columns is in Sheet2.

In ColB of sheet1 enter the below formula and copy down..This will return
the corresponding number from sheet2. Once done you can select Sheet1 ColB
copy>Paste special>Values>OK and then remove ColA

=INDEX(Sheet2!A:A,MATCH(A1,Sheet2!B:B,0))

If this post helps click Yes