Find Formula to search "Approx match"

[g1terra]

I have this formula on a large sheet that I need a way for it to find "approx matches" (without rewriting the entire formula)

So would anyone have an idea how to rewrite this to find anything with OFF in the name?

Here is the formula, i will have other names (with using OFF in them) so this is what I need to find APPROX Match


=IF('P1'!$U$13="SICK","",IF('P1'!$U$13="OWED","",IF('P1'!$U$13="OFF","",IF('P1'!$U$13="REQ OFF","",IF('P1'!$U$13="LOA","",IF('P1'!$U$13="VACA","",IF('P1'!$U$13>1,"X","")))))))

[CK76]

Try something like...

...IF(ISNUMBER(FIND("OFF",'P1'!$U$13)),""...

[g1terra]

THIS IS WHAT I GOT IT SAID false

=IF(ISNUMBER(FIND('P1'!$U$13="OFF","")),IF('P1'!$U$13="REQ OFF","",IF('P1'!$U$13="LOA","",IF('P1'!$U$13="VACA","",IF('P1'!$U$13>1,"X","")))))

[Syrkrasi]

You could also try this

=IF(OR('P1'!U13={"SICK","OWED","LOA","VACA"},ISNUMBER(SEARCH("OFF",'P1'!$U$13))),"",IF('P1'!U13>1,"X"))

[g1terra]

Got it sorry about that

[CK76]

Your formula syntax for FIND is off. Take a look at how I wrote the formula. As well, "REQ OFF" should be handled within FIND since it contains "OFF".

Do note that FIND is case sensitive, if you don't wan't it to be, use SEARCH like Syrkrasi's post.