Comparing data in two columns for matches

Closed
-
 rizvisa1 -
Hello,

I am lookin for a formula that can compare two columns of data to see if they match. For example:

A B C
1 3 NO
5 5 YES
6 1 NO

Your help is greatly appreciated. Thanks!

1 reply

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