Partial Match List

[asherthedevil]

I have 2 lists shown below. Obviously Larry Jones and Bob Smith are the same people as in List2 except List 2 has only first initials. I am trying to find a formula that will tell me the people in List 1 who are a partial match for List 2. Maybe put a mark by the ones that are a partial match. I am using Excel 2007. Thanks in advance...



List 1
Jones, Larry
Smith, Bob
Walters, V

List 2
Jones, L
Smith, B
Wallace, V

[Mallycat]

For the first list

• find the position of the comma
• add 2 to this number
• select that number of characters from the left
• search for this resulting string using vlookup in the other list

see attachement

Matt

[sglife]

List1 A1:A3
List2 B1:B3

Please Login or Register  to view this content.

and copy down