['=EXACT(A2,B2) If the two strings are identical, EXACT will return TRUE. If not, EXACT will return FALSE. ... ', '=IF(EXACT(A2,B2),"Yes","No") Note the EXACT function is case sensitive. ... ', '=A2=B2. This formula will return TRUE or FALSE, and will treat "Apple" and "apple" as the same.']