The exact function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If the two strings match, this function return True. If they do not match, it returns False.
Let’s look at the following example below. Where the text strings are the same, it displays True. If one text value is blank, it will return False. If both cells are blank, it will return True. Please keep this in mind when using this function.