Return multiple account numbers based on multiple names from a list

Joseph Adams

New Member
Joined
Sep 18, 2019
Messages
1
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.


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

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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
 
Upvote 0
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?
 
Upvote 0
It will show only the content part, like this:
ClaytonCayson
ColeIsaiah
ErickJaziel
GabrielKaleb
JedidiahBlaise

<tbody>
</tbody>

but you can amend it manually (by typing the column & row around the data), like this:
AB
1ClaytonCayson
2ColeIsaiah
3ErickJaziel
4GabrielKaleb
5JedidiahBlaise

<tbody>
</tbody>
 
Last edited:
Upvote 0
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:
Upvote 0
Test:

AB
1ClaytonCayson
2ColeIsaiah
3ErickJaziel
4GabrielKaleb
5JedidiahBlaise

<colgroup><col style="width:54pt" width="72" span="3"> </colgroup><tbody>
</tbody>
 
Upvote 0
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.
 
Upvote 0
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:
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top