Help with IF x = y Formula

[mwood]

I have a formula (that I thought was working) in a spreadsheet. It is fairly simple one -

=IF(M1118=N1118, "Match", "MISMATCH")

But it is working on some cells, and not on others. I can't see any difference in the formatting of the cells.

I was wondering if someone might be able to take a look and tell me that Im not crazy and that these cells do actually contain the same values.

Thanks!

 

[Scott Huish]

Do any of the cells contains spaces before or after the value?