I have an Excel workbook which contains 2 sheets. I want a macro to change the value in the main sheet based on the look-up table in the second sheet. The values in the first sheet are simple street addresses, the second sheet contains the same street address in one column and a corresponding number in the second column. I need to have that corresponding number automatically replace the street address each time it occurs in the main sheet.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition:
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
MS Excel current version and backward compatible to at least one older version.