Match first name and last name even if its flipped

[Saravanan13]

Hello all,

I am looking to check if first name is matching the last name for set of fields, but I need add one more condition whenever App1 First name = App2 last name then also its should be considered as match or App1 First name value should be replaced by App2 last name.

App1 First name	App2 last name	App2 First name	App2 last name
John	Doe	doe	John

[jdminton]

I made up a list of names to have some data. The first Excel tab represents App1 with all first names in the first field and last names in the last field. The second has half of the first and last names the same as app1, but the other half are flipped to test. After running, you should see 500 match initially and the remainder match after. In reality, with your data you will likely see some names with different variations of first names (Richard, Rick, Rich, etc.) that won't match due to this. You will also likely have to clean up the last names for Jr., III, multiple last names in one set). In those cases, you'll probably want to do the exact match first and then fuzzy match the unmatched. If you don't have any of these issues, you're very lucky 😉