cheryl27284
Technical User
I have two different columns with names from different databases. I need to see if the names in the second column are in the first column. The names are the same but in one column they are first, last and in the second column they are last first. Some names have intials and in the other column they do not. I need for the third column(with the formula) to return the name where it matches. For example I want it to look something like this: John Doe(first column)Doe N John(second column) Third column would have John Doe So I know he exist in the first column. If the first column has Sarah Smith and she is not found in the second column. The third colum would be blank.