In the following example, as you can see in the photo, comparing one Text string with a List of Cells can be identified by the EXACT function.
=EXACT("word",A2:A10)----->>>>answer is FALSE,FALSE,TRUE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,
The EXACT function is one of the TEXT functions of Excel.
It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.
The EXACT function has 2 arguments:
1. Text1 is the first text string.
2. Text2 is the second text string.