Finding exact string using a formula (excel)

i'm trying use find statement find multiple strings in context of larger formula. original formula i'm basing off of follows:

=if(isnumber(find("inc",a1))," ","y")

obviously, yields y if finds whatever text in " ". however, have many strings i'd check , need exact; ie when search inc , inc, not want inc counted. so, tried following formulas.

=if(isnumber(find(or("inc",inc"),a1))," ","y")

=if(sum(countif(a1,"* inc*","* inc*}))," ","y")

the second 1 works best, counts "inc" match. suggestions?

hi,

i recommend asking question in excel forum:

http://social.technet.microsoft.com/forums/en-us/home?forum=excel&filter=alltypes&sort=lastpostdesc

there's excel forum on over msdn side well, focuses more on vba:

http://social.msdn.microsoft.com/forums/en-us/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

this powershell forum.

---

don't retire technet! - (don't give yet - 12,950+ strong , growing)

Windows Server  >  Windows PowerShell