LinkBack URL
About LinkBacks
hi
I have two columns of names of people. I am wanting to do a partial value look up. i.e. if Column a has "A J Smith" it links to a "Alan Smith" in column B
Sorry trying to think of a clearer way to explain this but strruggling
thanks
R
Partial value lookup
hi
I have two columns of names of people. I am wanting to do a partial value look up. i.e. if Column a has "A J Smith" it links to a "Alan Smith" in column B
Sorry trying to think of a clearer way to explain this but strruggling
thanks
R
Partial matches (we call this fuzzy matching) are always problematic and can get quite complex. If column A has "A J Smith" and column B has "Alan Smith" and "Andrew Smith", what do you want to match? That is just scratching the surface. If column A has "A J Smith" and column B has "Alan Smyth" do you want that to be a match?
What is the source of the two lists and why would a name that you want to match be different in the two lists? That might help determine the algorithm for the match.
If all names in column A are initials followed by surnames, and column B in forename & surname.
then extract the first initial & surname from column A
Extract the initial & surname from column B
then you can do a lookup for a match
This is all well and good but you will get errors.
what if there is an Alice Smith as well?
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
I spoke to the person with the query.
We reckon if you could match by surname then someone can check through the matches and see what works.
@Sean,
I will test drive this and let you know.
Then Sean Thomas has you covered.
@6String and @Sean cheers guys I think I can work with that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks