Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advise required in relating two lists
I have a database of around 90000 addressess of which 30%
donot have zipcodes. Also I have a separate comprehensive list of zipcodes and which areas fall in which zipcode. I want to explore the possibilty of automating the process of putting zipcodes in the addresses. I was thinking of using a complex series of functions (vlookup, index, match etc.) or some sort of join operations between the two lists or some sort of VBA procedure. Please advise on the approach/technique which can be possibly used to achieve this aim. Thanks and Regards Neeraj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max (A1:A1), relating to other cells | Excel Worksheet Functions | |||
Relating cells | Excel Worksheet Functions | |||
Relating fields | Excel Discussion (Misc queries) | |||
Relating text to a value | Excel Worksheet Functions | |||
Relating text to a value | Excel Worksheet Functions |