Compare cells - diplay if not identical
Posted by Andonny on April 18, 2001 4:22 AM
I would like to find a formula which displays in column C the result if the 2 compared cells are not identical.
On C I should return "Appl" because it does not have the same spelling in sheet1 compared to sheet2. I would like to detect if something is not spelt correctly. The numbers in column A alway belong to the correct Item. At the moment I use vlookup to display in C all whats in column B on sheet1 and then compare them once they are side by side. It takes up a lot of bytes and I was hoping to find a formula that I only need to display when there is a change.
Thank you very much