When using this formula:
=if(AND('CASES LIST'!R4="No",P5="*neuro*"),"check","")

I am looking for the cell P5 if the text contains "neuro" in the text but it doesn't work when I add star* before and after.

1 Answer 1


Wildcards are not supported in simple IF formulas

Use the following


You can even turn it to an array using:


enter image description here

Functions used:

  • Remember you can always upvote an answer as well :) Feb 15, 2021 at 14:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.