Check in spreadsheet cell for exact match value from other cell text

Check in spreadsheet cell for exact match value from other cell text with specific Value Text.
For Example we are looking for the value from B2 Column if exist as part of the text in cell Column A2.
We run the formula in E2 to show TRUE or FALSE based on the Result.

To check if the text in cell A2 contains an exact match value from column D, you can use the following formula in cell C2:

This formula uses the “MATCH” function to look for the value in cell B2 (i.e., “SEO Book Pro Beta”) within column D. The “ISNUMBER” function is used to check if a match is found, and the asterisks before and after the search term indicate that we are looking for a partial match. The “0” in the MATCH function specifies that we are looking for an exact match.

If a match is found, the formula returns “TRUE”, and if not, it returns “FALSE”.

Note that this formula will check for partial matches, so if you want to check for an exact match, you can remove the asterisks around the search term in the formula.

Custom Value Name SEO Book Pro Beta in single cell to look for Exact Match in D Column Formula.

In this text we add “SEO Book Pro Beta” to use for our Match From Column B2 Cell Value.

And if The Value from Column B2 Exist in the A2 Cell Content

The Result in The Column E2 where we run the Formula will be TRUE otherwise will be FALSE
The Formula Below
=IF(ISNUMBER(MATCH(“*”&B2&”*”,A2,0)),”TRUE”,”FALSE”)