Excel: matching lists with different formats

[Closed]
Report
Posts
1
Registration date
Tuesday September 24, 2013
Status
Member
Last seen
September 24, 2013
-
Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
-
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

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!