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
[TABLE="width: 500"]
<tbody>[TR]
[TD]List 1[/TD]
[TD]ID Number[/TD]
[TD]List 2[/TD]
[TD]ID Number[/TD]
[/TR]
[TR]
[TD]John Albert Smith[/TD]
[TD]0054500845600[/TD]
[TD]Smith John Albert[/TD]
[TD]545008456[/TD]
[/TR]
[TR]
[TD]Robinson Susan[/TD]
[TD]85784[/TD]
[TD]Susan Robinson[/TD]
[TD]008570084[/TD]
[/TR]
[TR]
[TD]Michael Bay Johnson[/TD]
[TD]0054800412[/TD]
[TD]Johnson Bay Michael[/TD]
[TD]5480041200[/TD]
[/TR]
</tbody>[/TABLE]
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!
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]List 1[/TD]
[TD]ID Number[/TD]
[TD]List 2[/TD]
[TD]ID Number[/TD]
[/TR]
[TR]
[TD]John Albert Smith[/TD]
[TD]0054500845600[/TD]
[TD]Smith John Albert[/TD]
[TD]545008456[/TD]
[/TR]
[TR]
[TD]Robinson Susan[/TD]
[TD]85784[/TD]
[TD]Susan Robinson[/TD]
[TD]008570084[/TD]
[/TR]
[TR]
[TD]Michael Bay Johnson[/TD]
[TD]0054800412[/TD]
[TD]Johnson Bay Michael[/TD]
[TD]5480041200[/TD]
[/TR]
</tbody>[/TABLE]
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!