Hi,
A little help would be most appreciated please;
I want to look at a particular Cell in my worksheet and if it is blank to leave blank.
If the text within the Cell is exactly the same as the text in a particular Cell in another worksheet, to state "CORRECT".
If the text is NOT exactly the same, to state "WRONG".
eg, I am putting the formula in Cell C10. So if Cell A12 is empty, leave Cell C10 empty. If however, Cell A12 is not empty, and is exactly the same as Cell B16 in a different named worksheet, then put "CORRECT" in C10.
If the text in A12 is different to that in B16 of that different named worksheet, to put "WRONG" in Cell C10.
Hope this makes sense.
Thank you.
Bookmarks