How to use EXACT function in Microsoft Excel

Excel version in which EXACT function can work:

EXACT function can work in all of the latest version of Microsoft office.

About EXACT function in excel:

It compares two cells in excel, result will be TRUE if values in both cells are exactly same. Result will be FALSE if values are not same.

Syntax for EXACT Function:

=EXACT(text1, text2)


text1 and text2 = Two cell values to compare.

It is a case sensitive when comparing it with two strings.

Using EXACT function:

Finally, with different arguments combination to use EXACT function is given with the example.

Value1 Value 1 Formula Result
vlookup Vlookup  =EXACT(A3,B3) FALSE
vlookup vlookup  =EXACT(A4,B4) TRUE




Leave a Reply

Your email address will not be published. Required fields are marked *