Hello Guys! I would like to find a way to look values from one list onto another list, the problem is that those lists will not have the same format all the time and that´s when I would need to look for at least a partial match, let´s put it this way List 1 ID Number List 2 ID Number John Albert Smith 0054500845600 Smith John Albert 545008456 Robinson Susan 85784 Susan Robinson 008570084 Michael Bay Johnson 0054800412 Johnson Bay Michael 5480041200 Since I won´t find a perfect match looking for "Susan Robinson" from List 2 on List 1, I would like to look for a match where "Susan" and "Robinson" are valid in the same cell no matter their order or in case I do a search over ID Number I would like to search for example "85784" since there won´t be a perfect match that it would at least return me a cell where those numbers are contain. Thanks!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Match or Partial Match items in a list

Thread starter electrox
Start date Jan 16, 2018
Tags

list match number robinson susan

electrox

New Member

Jan 16, 2018

Hello Guys!

I would like to find a way to look values from one list onto another list, the problem is that those lists will not have the same format all the time and that´s when I would need to look for at least a partial match, let´s put it this way

List 1	ID Number	List 2	ID Number
John Albert Smith	0054500845600	Smith John Albert	545008456
Robinson Susan	85784	Susan Robinson	008570084
Michael Bay Johnson	0054800412	Johnson Bay Michael	5480041200

Since I won´t find a perfect match looking for "Susan Robinson" from List 2 on List 1, I would like to look for a match where "Susan" and "Robinson" are valid in the same cell no matter their order or in case I do a search over ID Number I would like to search for example "85784" since there won´t be a perfect match that it would at least return me a cell where those numbers are contain.

Thanks!