Massive Find and Replace

I have 3000 codes in column A1. I have 3000 company names in column A2. I
have a seperate worksheet that has column F with random codes. I need the
codes replaced with the company names. Any ideas?

Assuming you have Codes and Names in Sheet1
and Codes in Sheet2 Col F, which you want replaced by Names

Enter this in G1
=VLOOKUP(F1,Sheet1!A:B,2,False)
and copy down till the last row with Codes in Col F

You will get company names in Col G (and #N/A for those codes not found in
Sheet1)

You can then Copy Col G, Paste Special|Values on Col G and delete Col F


"Brian D" wrote:

I have 3000 codes in column A1. I have 3000 company names in column A2. I
have a seperate worksheet that has column F with random codes. I need the
codes replaced with the company names. Any ideas?

You can use VLOOKUP for this. Note, though, that A1 and A2 are
individual cells, not columns, so your post is a bit confusing. I
think you mean that you have codes in column A and names in column B -
suppose these are in Sheet1, and in Sheet2 you have your random codes
in column F. You can use this formula in G2:

=VLOOKUP(F2,Sheet1!A$1:B$3000,2,0)

and then just copy this down for as many random codes as you have.

Hope this helps.

Pete



On Dec 10, 12:02*am, Brian D Brian
wrote:
I have 3000 codes in column A1. *I have 3000 company names in column A2.. *I
have a seperate worksheet that has column F with random codes. *I need the
codes replaced with the company names. *Any ideas?

Thanks to you (Sheeloo) and Pete_UK. It works awsome.

"Sheeloo" wrote:

Assuming you have Codes and Names in Sheet1
and Codes in Sheet2 Col F, which you want replaced by Names

Enter this in G1
=VLOOKUP(F1,Sheet1!A:B,2,False)
and copy down till the last row with Codes in Col F

You will get company names in Col G (and #N/A for those codes not found in
Sheet1)

You can then Copy Col G, Paste Special|Values on Col G and delete Col F


"Brian D" wrote:

I have 3000 codes in column A1. I have 3000 company names in column A2. I
have a seperate worksheet that has column F with random codes. I need the
codes replaced with the company names. Any ideas?