Formula Help - If/Then

[Stapler1532]

I have 3 columns of data, and I want to edit the first column of data. How would I write a formula so that for each cell in the first column, it searches the second column for a match. If there is a match, then the first column cell is replaced by the corresponding third column cell. So for example, 100000 doesn't change because it does not appear in the second column (Child). 100001 appears in the second column, so it is replaced by the corresponding third column cell, which happens to also be 100001. However, 100005 ends up being replaced by 107547. There are more numbers/cells in the 2nd column than in the first, so to find a match from the first column to the second, it has to search the entire Child column -- it cant just search the same row. Thanks for the help in advance!

 

[Myrko]

Although your explanation in messed up, I believe what you are trying to do.

In cell B2 type =iferror(vlookup(A2,C:D,2,0),A2)

Let me know if I've understood it well and provided you with a viable solution.

 

[Stapler1532]

That worked perfectly! Thanks a bunch