Please help shrink massive manual task 10k records

[Todd]

Even if no time or no quick fix to this issue your theory
and comments would be greatly aprrecieated.

(e-mail address removed)

Need to ask if any vba or formula's combo's that might
help me.

I need to merge data by hand between 2 sheets - there is
no common id field.

I am on sheet 1 and search for a match to cusotmer name
and address on sheet 2 - then I copy a cutomer number that
only exists on sheet 1 over to sheet 2 - then later will
do vlookup of all data on sheet 1 to sheet 2

I am using visual interpretation of cusotmer names and
addresses from the two sheets.There are no exact matches.

Is there anything that can be done with matches or string
searches or something that will let me look for a street
number regardless of position in string(most street
numbers are at front of string).

I have the followng fields:
name,address, city, state, zip - zips are roken down to 3
fields (totalzip, 5 digit zip, and 4 digit zip)

I have all 5 digits of zip on both sheets - 4 digit zips
really only on one sheet.

ONE ISSUE IS WORDS IN NAMES NOT IN SAME ORDER

ANOTHER ISSUE IS THINGS LIKE SPACES AND "."'S AND AADDRESS
NOT BEING EXACT

I CAN PARSE OUT THE STREET NUMBER FOR ALLOT OF THE RECORDS.

Can we do a sort and then some type of match off of multi
fileds - even if it only gives me sub groups to manully go
through - maybe my visual way is the only way.

 

[Todd]

I may have a solution to address majority of records or
atleast a large part.

I will build a common unqiue identifyer for each customer
that will occur on both sheets by combining the street
address, the state, & the 5 digit zip this should give
some help but I hope you all will comment on how you would
attach such a thing. i figure will atleast cut job in half.

 

[Frank Kabel]

Hi
IMHO this requires manual work. In such cases an automatic match is
nearly impossible

 

[todd]

Thanks for the comment I want speand time dreaming but!!!!

I have first 5 digits zip & state on each sheet

I will build a merge filed that should give me a uniuq
commonidentifier.

either way there will be allot of manual work.

Todd