Compare Text in 2 worksheets where verbiage is slightly different

A

annem

I have 2 lists of clients, which may contain common clients, but the company
names may be written differently, such as Baptist Health System and Baptist
Medical Center. List A is the standard list that I wish to tie my records in
List B to. List A contains 6,000 records and B has 3,000. I would like
generate a list of 'possible matches for review manually'. Sorta like an
automated "Find All" in List A for each name in List B. Any ideas? Thanks,
Anne
 
C

CLR

Data > Filter > AutoFilter > click the arrow at the top of your column of
interest, then Custom > Begins with > and insert your first 3 or 4
characters > OK......refine as necessary.

Vaya con Dios,
Chuck, CABGx3
 
A

annem

Well, you know, that is what I've been doing. But it takes forever to check
them all this way. I was hoping for a variation of LOOKUP or MATCH that
would point me directly to the record, then I was going to modify the formula
to automatically pull data from another cell. I'm trying to set a key in
List B that matches the one in List A. Thanks, though. Anne
 
Top