Changing address information
 

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?

Changing address information
 

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/HintsA...roupUsers.aspx

hth,
hector.