How do I write an IF formula to compare the text in one column to another and if they are the same then the answer is YES. If they are not the same then the answer is NO.
EXAMPLE:
column A Column B column C
123 Main St 1234 Main St NO
855 Boyer Lane 855 Boyer Lane YES
Bookmarks