'Yes' or 'No' on two columns

[rhyspippard]

I have two columns of numbers. Some lines are identical and some are different. In a third field, I need to use a formula which flags by either 'yes' or 'no' whether each line in the two columns are identical.

Please forgive what must be a very simple query. Your help is, as always, much appreciated.

 

[Nimo]

Will this do?

if(a1=b1,"Yes","No")

Nimo

 

[MichaelRo]

Assuming Column 1 is A and Column 2 is B - Copy the following formula into Column 3 (C):

=IF(A1=B1,"YES","NO")

 

[rhyspippard]

Thank you guys, that is fantastic