[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • 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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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