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.
Value1 | Value 1 | Formula | Result |
VLOOKUP | vlookup | =EXACT(A2,B2) | FALSE |
vlookup | Vlookup | =EXACT(A3,B3) | FALSE |
vlookup | vlookup | =EXACT(A4,B4) | TRUE |
1 thought on “How to use EXACT function in Microsoft Excel”