Here's the formatted text in BBCode:
Yes, you can use the IF function along with the SEARCH or FIND function to check if a cell contains a specific string of text. Here's an example formula:
- =IF(ISNUMBER(SEARCH("Not mapped",G4)),"Disregard","Something else")
In this formula, the
SEARCH function looks for the text "Not mapped" within cell G4. If it finds it, it returns the starting position of the text. The
ISNUMBER function then checks if the SEARCH function returned a number (i.e. the text was found). If it did, the
IF function returns "Disregard". If not, it returns "Something else".
Note that the SEARCH function is case-insensitive, meaning it will find "not mapped" or "Not Mapped" as well. If you want a case-sensitive search, use the
FIND function instead.
Let me know if you need any further assistance.