Show EXACT Function in Excel (Table of Contents) EXACT Function in ExcelThe EXACT function is an inbuilt function in excel that is categorized under the TEXT function. It is used as a worksheet & VBA function in excel. EXACT function in Excel is used as a part of a formula in a cell of a worksheet & also integrated with other excel functions (IF, SUMPRODUCT & various other formulas of excel). It is most commonly used to perform a case-sensitive lookup between two strings. Excel is very easy to use and simple functions with two arguments. Definition Checks whether two strings are exactly the same and return TRUE or FALSE. It means the EXACT function in Excel compares two strings between two cells and returns TRUE if both values are the same & similar. Otherwise, it will return FALSE if both the strings do not match. EXACT Formula in ExcelBelow is the EXACT Formula in Excel: Explanation of the EXACT Function in Excel The EXACT formula in excel has two parameters, i.e. text1, text2.
The arguments can be entered manually, or cell reference can be given. The exact function is case-sensitive. i.e. Capital letters are not equal to small letters. It will return a FALSE value if there is a Leading or trailing space in any text strings, small or capital letters in a text string, Extra space between alphabets in a text, or uppercase or lower-case text between two strings or text. The equal sign in a formula of exact function can also be used, i.e. (text1=text2) to compare text strings. Instead of the EXACT function, the double equals (==) comparison operator is also used to Compare between two strings. For example, =X1==Y1 returns the same value as =EXACT(X1,Y1). How to Use EXACT Function in Excel?The EXACT function in Excel is very simple and easy to use. Let understand the working of EXACT function in Excel by some EXACT Formula example. Example #1 – Text Containing Uppercase LettersHere in the below-mentioned example. Cell B9 & C9 contains text strings; with the help of the EXACT function, I need to check whether the two cells have the same data or not.
Example #2 – Text Containing SpacesHere in the below-mentioned example. Cell B13 & C13 contains the text strings; with the help of the EXACT function, I need to check whether the two cells have the same data or not.
Example #3 – Ignoring Format PatternIn the below-mentioned example, Cell B18 contains $99, where it is in dollar value as currency format & C18 contains the 99, in number or general format. With the help of the EXACT function, I need to check whether the two cells have the same data or not.
Things to Remember
E.G. 0.08 = 8% $99 = 99 Recommended ArticlesThis has been a guide to the EXACT function in Excel. Here we discuss the EXACT Formula in Excel and how to use the EXACT Function in Excel along with practical examples and downloadable excel templates. You can also go through our other suggested articles – |