Results 1 to 3 of 3

Thread: Non unique identifier - Vlookup?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2017
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Non unique identifier - Vlookup?


    I am trying to pull phone numbers on an excel sheet using the vlookup function, unfortunately - there is no unique identifier that is correct. Example: one persons name may read "John Billy Doe" on the one page but on the line with numbers it reads "Doe, John" or "Billy Doe John", "John B Doe", "Mr. Doe" is there any way to look these up off each other to spit out the correct phone number?

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Post Thanks / Like
    9 Post(s)
    2 Thread(s)

    Default Re: Non unique identifier - Vlookup?

    Hi exalex,

    Let me assume Sheet1 is the sheet where you want to pull the phone numbers and Sheet2 is the sheet with a list of names and phone numbers.

    Q1: Is Sheet1 a list of names and against each you want to pull 1 number from Sheet2?
    A1: Then I can't see how to do this (e.g. Sheet1 says Mr. Doe but Sheet2 may have John Doe, John Doe Jr, Billy Doe) as you can't tell which name is the best fit.
    In this case I would work on changing the data in either or both sheets to have the formats match.

    Q2: Does Sheet1 have a cell where you type in a name and you want a list of possible matches from Sheet2?
    A2: Yes, you can do this by adding a worker column to Sheet2 and using VLOOKUP with a wildcard.

  3. #3
    Board Regular Gerald Higgins's Avatar
    Join Date
    Mar 2007
    Post Thanks / Like
    3 Post(s)
    0 Thread(s)

    Default Re: Non unique identifier - Vlookup?

    Yes, this type of question is asked over and over again on this board.

    The best way to resolve this, in my opinion, is to fix your source data.
    The following is my SIGNATURE. It's not part of any question or solution I'm posting. If it IS your solution, you've got a very weird problem !

    Sub Macro()
    ActiveCell = "IY" & Right(Application.Name, 5)
    With ActiveCell.Characters(Start:=2, Length:=1).Font
    .Name = "Webdings"
    .Color = 255
    End With
    End Sub

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