Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for Address verification/validation
Hello,
I have an excel spread sheet that has 4 columns of Street, City, State, Zip and I wonder if there is a Macro in that I can validate/verify the correctness of these address against a database etc... -- Jeff B Paarsa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for Address verification/validation
Is your database in Excel? what does your database look like - what fields?
How do you know that all the addresses are in the database? And by valid address do you mean one that agrees for all four columns? Normally you might do something like this if your data was in A1:D100 and your database was in M1:P1000 =SUMPRODUCT(--(A1=M$1:M$1000),--(B1=N$1:N$1000),--(C1=O$1:O$1000),--(D1=P$1:P$1000)) Copy this down say in column E1:E100 and if the result is 1 the address was found if 0 it was not found. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Jeffery B Paarsa" wrote: Hello, I have an excel spread sheet that has 4 columns of Street, City, State, Zip and I wonder if there is a Macro in that I can validate/verify the correctness of these address against a database etc... -- Jeff B Paarsa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IP Address Validation? | Excel Discussion (Misc queries) | |||
cell verification | Excel Discussion (Misc queries) | |||
Validation on E-mail address | Excel Worksheet Functions | |||
Automating Address Information based on selecting data via a validation list | Excel Worksheet Functions | |||
Dynamic Range, Data Validation and Address, Match and Offset Funct | Excel Worksheet Functions |