Comparing data in two columns for matches

Closed
Quick hands - Jan 26, 2010 at 11:17 AM
 rizvisa1 - Jan 29, 2010 at 03:18 PM
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")
1