Excel Function : EXACT
Category
Text
Description
Checks to see if two text values are identical
Microsoft Excel Reference Page
https://support.office.com/en-us/article/EXACT-function-d3087698-fc15-4a15-9631-12575cf29926
Syntax and Description of the EXACT Excel Function
EXACT meaning EXACT text EXACT text in excel EXACT. The syntax of the INDEX function is as below: INDEX (array, row_num, [column_num]) Array is a reference to a range of cells. The col_index_num is the number of the column in table_array. The row_index_num is the number of the row in table_array. The range_lookup is optional. It has two values, either TRUE or FALSE. The default value is TRUE. The second image below shows the syntax of the INDEX function. The array is the range of cells that you want to search. The row_num is the row number in the array from which the row is returned
About EXACT Excel Function
The EXACT function is used to compare two text strings, taking into account upper and lower case letters, to see if they are exactly the same. If the two text strings are the same, the EXACT function will return TRUE. If the two text strings are not the same, the EXACT function will return FALSE.
