Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 434
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge address information in Excel into Word? Matt Excel Discussion (Misc queries) 1 August 30th 07 05:34 PM
Functions for manipulating and filtering address information devdas777 Excel Discussion (Misc queries) 0 November 15th 06 09:33 PM
Address information in each cell scubadiver Excel Discussion (Misc queries) 0 November 8th 06 04:04 PM
How do I separate address information from within an Excel cell? Scott Excel Discussion (Misc queries) 1 December 7th 05 11:10 PM
I need help to link information such as name, address and phone t. kimbo Excel Worksheet Functions 1 November 24th 04 07:17 AM


All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"