Compare 2 column of names

[shimaa01234]

I want to write "Yes" if match the first name of the column "A" with the first name of the column "B"
And write "Yes" if the two match the name of the column "A" with a name of the column "b" etc. .........
And writing "no" if you do not similar to anything of Name

NAME1	NAME2	RESULT
AAAB	BAAC	YES
CABCD	CHIJK	YES
FGLM	DSER	NO
XYUZ	XYUZ	YES

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[shimaa01234]

You are a wonderful person
Thank you very much for your generosity
The formula works like a charm.

 

[Snakehips]

You are most welcome.

 

[shimaa01234]

Unfortunately, Mister "Snakehipes"
You could modify the formula so that given "Yes" with similarity of the first three names , to be among them First Name

 

[Snakehips]

Do you mean for a YES the first name should always be matched? If the first name does not match then NO regardless of any other matches?

Excel 2007
	A	B	C
1	NAME1	NAME2	RESULT
2	Peter Gabriel Mikhail	Peter Gabriel Mikhail	YES
3	Gabriel Peter Mikhail	Peter Gabriel Mikhail	No
4	Tom Gabriel Mikhail	Peter Gabriel Mikhail	No
5	Peter Mickey Mouse	Peter Gabriel Mikhail	?????
Sheet2

If the above not correct then please give example.

 

[shimaa01234]

Thank you again, Mr. "Snakehipes"
I am shy, from generosity

 

[Snakehips]

I have to say that I am confused.

In my post #14 ...... are the example results in C2:C4 as you would expect?

Also please confirm what result you would want in C5 YES or No ?

 

[shimaa01234]

Yes, Please Mister "Snakehipes"

 

[Snakehips]

Then all you are wanting is to match the first name or not ???????

In which case there is no need for a UDF and below is an example of how you might use standard formulas.

Excel 2007
	A	B	C
1	NAME1	NAME2	RESULT
2	Peter Gabriel Mikhail	Peter Gabriel Mikhail	YES
3	Gabriel Peter Mikhail	Peter Gabriel Mikhail	NO
4	Tom Gabriel Mikhail	Peter Gabriel Mikhail	NO
5	Peter Mickey Mouse	Peter Gabriel Mikhail	YES
Sheet2

Cell Formulas
Range	Formula
C2	=IF(OR(A2="",B2=""),"",IF(LEFT(A2,SEARCH(" ",A2&" ",1))=LEFT(B2,SEARCH(" ",B2&" ",1)),"YES","NO"))

I remain... 'Confused of Coventry'