What you want can be done either by 'VLOOKUP' function or 'MATCH'.
Assuming you have updated address in column C and original address in Column F.

Put below formula say column D.
=VLOOKUP(Cn,F:F,1,0) or =MATCH(Cn,F:F,0)
For the entries you get other than "#N/A" is on column F.

If you don't like re-calculation, you can make this into VBA code.

Regards,
mas