HUGE problems with detecting multiple text strings a single cell

[BillTony]

I am trying to find a method in which to detect 2 separate Text Strings within a given cell.

In a nutshell - user input on a form I have is not always what it could be.

So, if the expected answer would be "No Luck," some users will invariably enter "No Luck."

Unfortunately, according to the specifications I have been supplied, the latter is "acceptable..."

Below I'm including 2 snippets that work perfectly well independently of each other - the issue I am having is how to COMBINE them into a single statement (with AND somehow?).

I've tried quite a number of variations so far, but haven't come up with anything usable!

Thanks in advance!

=IF(ISNUMBER(SEARCH("No",A1)),"Text String Found","Not present")

=IF(ISNUMBER(SEARCH("Luck",A1)),"Text String Found","Not present")

 

[BillTony]

Sorry, the 2nd "No Luck" in the example had several spaces between the 2 words - I guess the forum logic "proof-read" them out...

Thanks again!

 

[Fluff]

How about
=IF(AND(ISNUMBER(SEARCH("No",A1)),ISNUMBER(SEARCH("Luck",A1))),"Text String Found","Not present")

 

[jtakw]

Hi,

This could also work:

Book1
	A	B	C
1	no luck		Text String Found
Sheet92

Cell Formulas
Range	Formula
C1	=IF(ISNUMBER(SEARCH("*No*Luck*",A1)),"Text String Found","Not Present")

 

[BillTony]

Thanks to you BOTH for such timely responses to a thorny issue - I will give it a shot as soon as I return to the office!