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
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
=IF(A1=B1,"YES","No") this will work perfectly but sometimes we need exact comparison than we can use =IF(EXACT(A1,B1),"Yes","No")
Formula:
Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
You may also want to incorporate TRIM in there as a rogue space on the start/end is notorious for failing comparisons.
eg
orPlease Login or Register to view this content.Please Login or Register to view this content.
In general the easiest way here is =A1=B1 It will display TRUE or FALSE
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks