Print "YES" when cells match, "NO" otherwise

[Alain Dekker]

Hi,

If I have a long list of names in one column, and a second column with
mostly the same names, but a few differences, how can I write a formula that
will print "YES" in a third column if cells match, and "NO" when they
mismatch?

Thanks,
Alain

 

[Andy B]

Alain

In the third column use:

=IF(A2=B2,"Yes","No")
and fill down

Andy.

 

[Alain Dekker]

Trivial! Thanks very much.

Regards,
Alain

Alain

In the third column use:

=IF(A2=B2,"Yes","No")
and fill down

Andy.

 

[Peo Sjoblom]

=IF(A2=B2,"YES","NO")

adapt to fit your data copy down