Don't miss that Excel's EXACT function is an easy way to tell if the data in two cells matches.
It's case sensitive but will not detect differences in formatting. A TRUE result is given if the cells match, a FALSE result if not.
It's more useful to use in conjunction with another formula. VLOOKUP is not case sensitive, but you can nest EXACT in a LOOKUP formula to do a case sensitive search.