How do I add multiple IF functions on 1 cel, without blocking it on the first line. As you can see, column D contains a bunch of text. In column A, I want to categories them.

It works up until the first line, but it gives and error because he doesn't find "wheel". I want it to ignore this, and just go to the second line when he doesn't find "wheel", etc

See image below

Can anyone help me?

enter image description here

Would you know how to fix this problem? IF the word "paypal" is in cel D, AND there is a specific amount in cel C, I want it to categorize it.

See image.


1 Answer 1


Matter is with SEARCH() returning error when failing to find your criteria.

To avoid that wrap your SEARCH() in IFERROR() like this:

=IF(IFERROR(SEARCH("wheel", A41),),"car",
 IF(IFERROR(SEARCH("banana", A41),),"fruit","No matches"))
  • Awesome! Thanks a lot!
    – Lloyd
    Commented Sep 4, 2020 at 9:15
  • 1
    @Lloyd If the answer resolved your issue, please mark it as accepted by clicking on the grey checkmark on the left
    – adiga
    Commented Sep 4, 2020 at 18:06

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.