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