Replace cell values in one spreadsheet from another

I have two excel files, one is a master list of addresses (10000 rows), the other is a smaller list with updated addresses for about 1000 entries on the master list. I need to replace the old addresses in the master list with the updated addresses. What is the best way to do this?

I haven't. I'll give it a shot right now

Looks like that's gonna work for me. Thanks for the tip!