Results 1 to 10 of 10

Thread: Return multiple account numbers based on multiple names from a list
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Return multiple account numbers based on multiple names from a list

    Apologies in advance. This is my first time posting.

    I have a list (DATA A) with two columns of data, Name and Account. I am trying to match the account numbers from Data A to a separate list (List B) which contains names, but where the names are separated into two separate columns for First Name and Last Name. Additionally, I do not want the matching to be exact so that First Name = John and Last Name = Doe will pull the account number from Data A even if the corresponding name from Data A is John Doe, Doe John, John F Doe, and would not pull account numbers from names such as Jane Doe, Doe Jane, John Smith, and so on. The condition is that both "John" and "Doe" be present. Finally, I am trying to get a list of all unique account numbers since my Data A list will have multiple variations of the name and with different account numbers.

    The following is the direction I have been going in, but I can't seem to combine both First Name and Last Name.[IMG]C:\Users\JADAMS\Documents\Mr. Excell\two lists.PNG[/IMG]

    I apologize, not sure if this image is going to past in. I guess I will be out of luck if it doesn't.

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,265
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    I doubt I'll solve this as it sounds fiddly and I dont have much time but FYI

    You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

    https://www.mrexcel.com/forum/about-...tachments.html

  3. #3
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,149
    Post Thanks / Like
    Mentioned
    43 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    You could post a sample data as table.
    To copy a simple table from worksheet:
    1. In your worksheet select the table/range
    2. In the menu, select border icon > select All Borders > then copy.
    3. Back to the thread > in the reply box paste the table

  4. #4
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,265
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    Quote Originally Posted by Akuini View Post
    You could post a sample data as table.
    To copy a simple table from worksheet:
    1. In your worksheet select the table/range
    2. In the menu, select border icon > select All Borders > then copy.
    3. Back to the thread > in the reply box paste the table
    You sure this works? I can't get it to work, it posts the cell contents but not the borders.
    Is there some setting that needs to be on to achieve this?

  5. #5
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,149
    Post Thanks / Like
    Mentioned
    43 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    It will show only the content part, like this:
    Clayton Cayson
    Cole Isaiah
    Erick Jaziel
    Gabriel Kaleb
    Jedidiah Blaise

    but you can amend it manually (by typing the column & row around the data), like this:
    A B
    1 Clayton Cayson
    2 Cole Isaiah
    3 Erick Jaziel
    4 Gabriel Kaleb
    5 Jedidiah Blaise
    Last edited by Akuini; Sep 19th, 2019 at 07:13 AM.

  6. #6
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,265
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    testing...

    d e f
    a b c

    I can only see content atm, just about to press Post Quick Reply button.
    @Akuini: Can you post your test Excel file?
    Last edited by Special-K99; Sep 19th, 2019 at 07:30 AM.

  7. #7
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,149
    Post Thanks / Like
    Mentioned
    43 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    Test:

    A B
    1 Clayton Cayson
    2 Cole Isaiah
    3 Erick Jaziel
    4 Gabriel Kaleb
    5 Jedidiah Blaise

  8. #8
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,149
    Post Thanks / Like
    Mentioned
    43 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    Earlier at post 5, I posted via GO Advance but in post 7 I just did it again by pressing Post Quick Reply button, the result are just the same.
    I don't know why it's different from yours.

  9. #9
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,149
    Post Thanks / Like
    Mentioned
    43 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    Can you post your test Excel file?
    Here's the file:
    https://www.dropbox.com/s/enyac3s6ha...%201.xlsx?dl=0

  10. #10
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,265
    Post Thanks / Like
    Mentioned
    21 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Return multiple account numbers based on multiple names from a list

    A B
    1 Clayton Cayson
    2 Cole Isaiah
    3 Erick Jaziel
    4 Gabriel Kaleb
    5 Jedidiah Blaise


    That's weird, hasn't worked.
    Not to worry, I don't want to clog up this thread, thanks anyway.
    Last edited by Special-K99; Sep 19th, 2019 at 07:50 AM.

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
  •