Excel: Compare 2 column of names


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


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of October 05, 2014.


For more resources for Microsoft Excel