Excel: matching lists with different formats

Closed
KnitClown Posts 1 Registration date Tuesday September 24, 2013 Status Member Last seen September 24, 2013 - Sep 24, 2013 at 03:34 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Sep 25, 2013 at 11:11 AM
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!

1 reply

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Sep 25, 2013 at 11:11 AM
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.
0