Changing address information

[scr]

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?

 

[Héctor Miguel]

hi, !

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?

suggestions ?...
-> http://www.cpearson.com/Excel/HintsAndTipsForNewsgroupUsers.aspx

hth,
hector.