|
Posted to microsoft.public.excel.misc
|
|
|
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.
|