top of page

Excel's EXACT function

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.

bottom of page