Any suggestions?

Check your other posts for answers.

Regards,
Fre.


"scr" wrote in message
...
I have an original list of addresses. A "reroute" list is provided. If
columns A, B, & C on the original list match columns A, B, & C on the
"reroute" list the addresses in columns D, E, F, G & H must be changed to
the new addresses listed on the "reroute" list columns D, E, F, G & H.

If, however, there is not match then the address in the original list
needs
to stay the same.

Any suggestions?