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!