IFERROR IF FIND Help

[tiffanimk1]

I'm trying to write a formula to find keywords in a text string. Since there are variations, I was using a Find function for the keywords that are consistent throughout. But the Find function errors after the first and returns #Value throughout the rest of the nested IF. I tried using an IfError, but it's still not capturing correctly. Where am I going wrong?

Original:
=IF(FIND("ACCESS",K3),IF(FIND("PACKAGE",K3),IF(FIND("ANNUAL",K3),"INCLUDE"),"EXCLUDE"))
With IFERROR:
=IF(IFERROR(FIND("ACCESS",K3),IF(IFERROR(FIND("PACKAGE",K3),IF(IFERROR(FIND("ANNUAL",K3),"INCLUDE"),"EXCLUDE","INCLUDE")))))

Any help is appreciated!

 

[azumi]

Try provide example in excel file for better explanation

 

[Pratsexcel]

hi,

Please try following formula

=IF(OR(ISNUMBER(SEARCH("Access",K3)),ISNUMBER(SEARCH("Package",K3)),ISNUMBER(SEARCH("annual",K3))),"Include","Exclude")

Regards,

Pratish.

 

[Nebu]

Hi:

Use the following formula
=IFERROR(LOOKUP(2^15,SEARCH(A1,$H$2:$H$4),$I$2:$I$4),"Exclude")

Thanks

 

[bosco_yip]

Try……….

=IF(OR(ISNUMBER(SEARCH({" access "," package "," annual "}," "&A1&" "))),"Include","Exclude")

Edit :

1. Space needs to be added ensure the criteria is an independent word and not part of a word.

2. FIND needs to be replaced with SEARCH so that the check is not case-sensitive

Regards