Results 1 to 4 of 4

Thread: VLOOKUP VS INDEX & MATCH | DATA Matching
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular Joneye's Avatar
    Join Date
    May 2010
    Location
    UK
    Posts
    742
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VLOOKUP VS INDEX & MATCH | DATA Matching

    Hello all,

    Using a mac so cannot post my data sadly. (Excel for Mac latest version).

    Brief
    * One workbook, data extract needs to be checked against another list. One source of data is from a CRM another from excel. All data has been cleaned and sat in two tabs.

    Objective
    * Check if items in list A match or are close to List B.

    Example
    * List A company name "Jon 123" (8000 indiviudal references)
    * List B company name "Jon V1" (630 indiviudal references)

    How on earch can i check list B against list A bringing in the cloest option for each line of A.

    Help is appreciated.
    Its not after you've lost everything till your free to do anything....

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VLOOKUP VS INDEX & MATCH | DATA Matching

    Your remark "the closest option" makes it necesssary that you create here two small fake lists to illustrate this point.
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #3
    Board Regular Joneye's Avatar
    Join Date
    May 2010
    Location
    UK
    Posts
    742
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP VS INDEX & MATCH | DATA Matching

    Quote Originally Posted by Aladin Akyurek View Post
    Your remark "the closest option" makes it necesssary that you create here two small fake lists to illustrate this point.
    Im searching for a loook up funciton to match or get close to a company name, one database has JON XXX another due to input errors has JON YYY, simply looking for a fomula to return what is close so data can be sensor checked further.
    Its not after you've lost everything till your free to do anything....

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: VLOOKUP VS INDEX & MATCH | DATA Matching

    Quote Originally Posted by Joneye View Post
    Im searching for a loook up funciton to match or get close to a company name, one database has JON XXX another due to input errors has JON YYY, simply looking for a fomula to return what is close so data can be sensor checked further.
    I'm not going to create an example input and an associated output. The following will be as sketchy as your way with fake ranges...


    =LOOKUP(9.99999999999999E+307,SEARCH("JON",$A$2:$A$100),$B$2:$B$100)
    Assuming too much and qualifying too much are two faces of the same problem.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •