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)

Parameters:

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.

Value1Value 1FormulaResult
VLOOKUPvlookup =EXACT(A2,B2)FALSE
vlookupVlookup =EXACT(A3,B3)FALSE
vlookupvlookup =EXACT(A4,B4)TRUE
    

 

 

 

This Post Has One Comment

Leave a Reply

Close Menu