Excel Function : EXACT

Download now!

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.