Replacing data from one sheet to another

[brjv42]

Hello,

I have a current spreadsheet that contains a mailing list for one of my organizations. The problem is that my county has changed everyone's address to 911 addresses so houses are easier to find.

I have two spreadsheets...the first one with all the names and old addresses and all types of other information...the second one includes the old addresses with the new replacing addresses next to it. I would just copy and paste but both spreadsheets are not in alphabetical order and it would take forever to change them all.

My question is...what is the easiest way to search throughout each spreadsheet, find the matching old addresses and replace the old address with the new.

Please HELP!!!!

Thanks, brjv42

 

[onlyadrafter]

How many cells does the address take up?


If it is just one, try using VLOOKUP.

If not, please supply an example of the spreadsheet.

 

[brjv42]

The address only takes up one cell...

I did try to code VLOOKUP, but I don't know if I did it correctly, it keep giving me the wrong cell references.

Any help with this would be appreciated...

Thanks

 

[onlyadrafter]

Hello,

Book 12 is the file with name, address and other information
Book 13 is the file with both new and old address.

Book 12 column A contains the old address
Book 12 column B contains the new address

Book 13 column A contains the old address
In B2 on book 13 enter this formula

=VLOOKUP(A2,[Book12]Sheet1!$A:$B,2,0)

and copy down as far as required.

Has this helped? change the cell refs as required.

 

[brjv42]

Yes, that worked....


Thank you so much!!!

brjv42