Text comparison. Exact and partial matches.(Microsoft Excel)

Excel has several functions to check for string matches.
There are two types of functions to check for exact matches and partial matches.
These functions are mainly used with the judgment function, the conditional aggregation function, and the search function.
This section introduces the characteristics of each function and the appropriate situations for each.