Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Microsoft Excel VLOOKUP Help Needed

Posted on 2012-03-30
Medium Priority
351 Views
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
Question by:mmcgillo88
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 46

Expert Comment

ID: 37790908
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

LVL 14

Accepted Solution

Stacy Brown earned 2000 total points
ID: 37797532
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month5 days, 17 hours left to enroll