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 :) Commented Feb 15, 2021 at 14:25

Your Answer

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

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