Address book worksheet problem

[Guest]

I have two long worksheets that serve as address lists.
My problem is I believe there is duplication on the lists.
Here's an example of the data
Full Name First Last Salutation Home Address BusAddress Sponsor

John Doe John Doe Mr. 4 Bird Lane 5 Spire St. N
Jill Xo Jill Xo Ms. 2 Quite St None
Y

I need to check for any duplication in the address fields and then somehow
flag the field in the other worksheet. So I may need to check "4Bird Lane"
agains the entire address field in the other worksheet. I don't really want
to combine the sheets because the column fields are not all the same and are
used for different purposes.

Is this a lookup or match command? I'm not sure?
Help
Email

 

[Guest]

Without more specifics, this basic formula, copied down a helper column,
will find the duplicates........change the cells accordingly.

=VLOOKUP(A1,Sheet2!D,1,FALSE)

But, you still will probably have other duplicates that this method will not
find......and those are due to the fact that the addresses may be entered
differently on different rows, such as 4 Bird Lane, 4Bird Lane, 4 Bird Ln.,
etc etc.........


hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks.
Any ideas on how to address the second issue, with the addresses being close
to matches but not exact: 4 Bird Lane or 4 Bird Ln.
Is there any way to use an * or something?

 

[Guest]

I've tried the formula and I get the first part, entering the lookup cell and
the array to search. I dont really understand the 1,FALSE part of the
formula and where these should reference.

 

[Guest]

It is much a pain........you can try adding a helper column to the list with
the formula =Left(D1,5) or 4 or some beginning characters, and then modifying
the Vlookup to something equiable, like...

=VLOOKUP(left(A1,4),Sheet2!C:C,1,FALSE)

this may give you some matches that start out the same.........but like I
said, it's a pain


Vaya con Dios,
Chuck, CABGx3

 

[CLR]

1 means to return reference from the same column where the Vlookup finds the
value it's seeking, "FALSE", tells the Vlookup formula not to return any
value except for an exact match....leave them both just as in the sample,
only change the cell references.

hth
Vaya con Dios,
Chuck, CABGx3