Replace question (Excel 2007)

[supernovartis]

Hi everyone,

If somebody can help me, I have the following problem. In sheet 1, I have a list that looks like this (much larger in reality):

Name Code

Firm 1 a1
Firm 2 a2
Firm 3 a3

In sheet 2 (of the same document), I have another list like this:

Name Value

Firm 1 175
Firm 2 230
Firm 3 101

Basically, I want to replace sheet 2 names with the codes, so it looks like:

a1 175
a2 230
a3 101

Is that possible?

Thank you in advance.

[Pete_UK]

Insert a new column B in Sheet2 and put this formula in B1:

=IFERROR(VLOOKUP(A1,Sheet1!A:B,2,0),A1)

then copy down. Then highlight column B, click <copy> then right-click, choose Paste Special and click Values | OK and press the <Esc> key. Then you can delete the original column A.

Hope this helps.

Pete

Not sure why your post count is shown as zero.

[supernovartis]

Thanks a lot, worked like a charm!!

ps. I just registered in the forum, that's why zero posts.

[Pete_UK]

ps. I just registered in the forum, that's why zero posts.

Yes, but it should have shown as 1 on your first post.

Anyway, glad to be of help - please mark the Thread as Solved if you think it is.

Pete