Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 374
  • Last Modified:

Microsoft Excel VLOOKUP Help Needed

Is there a vlookup formula to see if names of two clients (for example) resemble one another but may not be exact matches? for example may be company ABC LLC and company ABC, they match just minor differences.
0
mmcgillo88
Asked:
mmcgillo88
1 Solution
 
aikimarkCommented:
There are algorithms for fuzzy string comparison.  You might apply one of these and determine at what level you consider the two strings 'similar'.

Our .Net user group had a coding contest a few months ago, to code up a Levenshtein comparison.
http://en.wikipedia.org/wiki/Levenshtein_distance

Note: near the end of the wiki article, there is a list of other fuzzy comparison algorithms.  You should look at those and decide which one is most suitable for you.
0
 
Stacy BrownSenior Applications AdministratorCommented:
In a VLOOKUP, the last variable can be set to TRUE or FALSE.  FALSE returns only an exact match so you would want to set your last variable to TRUE.  Like this:

=VLOOKUP(D2, ClientInfo, 2, TRUE)

I've attached a document I create a while back on VLookups.  I hope you find it helpful
VLOOKUP-Crash-Course.doc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now