Excel: matching lists with different formats

Closed
KnitClown Posts 1 Registration date Tuesday 24 September 2013 Status Member Last seen 24 September 2013 - 24 Sep 2013 à 15:34
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 25 Sep 2013 à 11:11
I have two lists of names that I am trying to compare. One list is divided into two cells, one for first and one for last names. The other list has the names written last name, first name. I would like to compare the lists and find out what names match. The formula =ISNA(MATCH(E1,A:A,0) ) worked for two lists of names that are formatted the same. Is there a way to request a partial match?

Thanks for your help. What a great resource this list has been!
Related:

1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
25 Sep 2013 à 11:11
KnitClown, Good morning.

I did an example to help solving your question.
https://www.cjoint.com/c/CIzriDRuKbK

Take a look at it and tell us if it worked for you.
I hope it helps you.

Greetings from Brazil.