Counting cells if both columns show matching ref numbers.

[dandavis1]

Please see attached.

I need to create a formula that shows yes or no if column c and d both match. So with this example e3, e4, e5 should show yes and e6 should say no.

Can this be done?

Many thanks.

[icestationzbra]

if you can do with TRUE / FALSE, you can use:

=EXACT(C3,D3)

or just: =C3=D3

or, if you are particular about "yes" / "no", you can wrap either of the above around an IF statement like:

=if(EXACT(C3,D3),"yes","no")

[jraj1106]

Hi

You can try this too:

=IF(C3=D3,"YES","NO")