Hi - I have two worksheets with employee data in over 7,000 rows. I need to
see which names on worksheet 1 are in worksheet 2. On both worksheets the
full names are in only one column and they are in varying order in each cell.
So for example:
B1 = Last name First name Middle name
B2 = First name  last name middle name

There are no commas differentiating first name from last name on either
worksheet. And they are Brazilian names so most of the people have more than
one last name or middle name, so they could go in any order and they vary in
number of names per person. I have no way to determine where they should be
separated if I wanted to input a comma myself.

I put the cells on both worksheets in the same format and trimmed both so
there are no extra spaces. However when I do a vlookup I just get NA. I know
that the majority of the names in Worksheet 1 are in Worksheet 2 so I'm
definitely not setting up the right function.

What now?? Any suggestions? Your help is much appreciated.

Thanks,
Alison