I have a column 'A' listing every client (with additional columns showing their addresses) and another column 'H' showing specially selected clients from column 'A' without the addresses. The names are identical or nearly so.
I need to identify which clients in column 'A' also exist in column 'H' so I can create a mail merge of just those clients.
I'm in over my head.
Last edited by jcoshow; 06-25-2011 at 07:48 PM.
IMO a sample workbook would help in this situation!
HTH
Regards, Jeff
What doesmean?The names are identical or nearly so
If it is identical, then you could use COUNTIF or VLOOKUP to set a "mail merge select" flag. If it's not identical, it would be more complicated ... but maybe still possible ... but you need to explain and give examples.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
By '"nearly so" I meant there may be some slight differences like a missing period after an initial.
I have attached a brief example from the real file. Column H are the clients I need for the final mail merge, column A is the listing of all clients.
Jim
In I1 you could use the Vlookup function, but instead of using a 0 at the end for an exact match, leave it blank which results in the closet match.
Also, list should be in ascending order
=VLOOKUP(H1,$A$1:$F$9,2)
If it's just a missing period on one side or the other, you could use the formula:
=IF(SUMPRODUCT(--(SUBSTITUTE($H$1:$H$10,".","")=SUBSTITUTE($A1,".","")))>0,"print","")
to set a "flag".
If it's other variations, you will need to extend the substitutions, etc.
Regards
I tried your formula but I didn't get the result I'm seeking. I didn't describe my goal well enough, let me try to clarify:
In the updated attached example I would like to end up with a YES or NO on each row signifying if the name in column B also exists in column H. I will then sort out the NO's and complete the emerge on the remaining YES names.
I have to run this merge regularly and it's become too big to do it manually.
thanks in advance.
Jim
See amended example
Regards
Excellent TMShucks, thank you!
Jim
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks