I need a formula for excel

Solved/Closed
Will Riker - May 23, 2010 at 02:21 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 23, 2010 at 02:34 PM
Hello,

Here is what I need and cant find anywhere:
IF A12="text1 (anywhere in text)",then b2="text2"

please help provide a formula that can accomplish this, asap.

Also really there needs to be a new search engine for excel formulas google just does not cut it specific problems are "" in formula confused the heck out of google search and especially if look for an exact formula where you want to quote the formula with the quotations in it and * wildcards are garbage too considering some formulas contain that for multiplication and so on just saying there needs to be an excel format formula friendly search engine in todays day in age

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
May 23, 2010 at 02:34 PM
try this

=IF(ISERROR(FIND("text1", A12,1)), "Not found", "text2" )
1