1

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

Wildcards are not supported in simple IF formulas

Use the following

=if(AND($R$4="No";REGEXMATCH(P5;"neuro"));"check";"")

You can even turn it to an array using:

=ArrayFormula(if(($R$4="No")*(REGEXMATCH(P5:P,"neuro")),"check",""))

enter image description here

Functions used:

1
  • Remember you can always upvote an answer as well :) – marikamitsos Feb 15 at 14:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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