IF CELL CONTAINS COMBINATION OF TWO SPECIFIC TEXT VALUES, RETURN TRUE OR FALSE

[JTH94BT]

I need to return "TRUE" for all cells that contain "APP ONLY" AND "FOR QQ" and "FALSE" for any cell that contains only "APP ONLY" and not "FOR QQ":

Product Description	TRUE OR FALSE
APP ONLY 12M TEST FOR QQ
GBP 1 OFF APP ONLY 24M TEST FOR QQ
APP ONLY 6M FOR QQ
APP ONLY TEST 24M
APP ONLY 12M

I have used "=IF(ISNUMBER(SEARCH" for other scenarios where there is only one piece of text that I need to search for, but I'm unsure how to incorporate a second specific text

 

[FormR]

Hi, you could try like this:

Book1
	A	B
1	Product Description	TRUE OR FALSE
2	APP ONLY 12M TEST FOR QQ	TRUE
3	GBP 1 OFF APP ONLY 24M TEST FOR QQ	TRUE
4	APP ONLY 6M FOR QQ	TRUE
5	APP ONLY TEST 24M	FALSE
6	APP ONLY 12M	FALSE
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=AND(ISNUMBER(SEARCH({"APP ONLY","FOR QQ"},A2)))

 

[bobsan42]

something like this:

=IF(NOT(ISERR(SEARCH("APP ONLY",A2))),IF(NOT(ISERR(SEARCH("FOR QQ",A2))),TRUE,FALSE),"")

 

[JTH94BT]

Hi, you could try like this:

Book1
	A	B
1	Product Description	TRUE OR FALSE
2	APP ONLY 12M TEST FOR QQ	TRUE
3	GBP 1 OFF APP ONLY 24M TEST FOR QQ	TRUE
4	APP ONLY 6M FOR QQ	TRUE
5	APP ONLY TEST 24M	FALSE
6	APP ONLY 12M	FALSE
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=AND(ISNUMBER(SEARCH({"APP ONLY","FOR QQ"},A2)))

Hi, you could try like this:

Book1
	A	B
1	Product Description	TRUE OR FALSE
2	APP ONLY 12M TEST FOR QQ	TRUE
3	GBP 1 OFF APP ONLY 24M TEST FOR QQ	TRUE
4	APP ONLY 6M FOR QQ	TRUE
5	APP ONLY TEST 24M	FALSE
6	APP ONLY 12M	FALSE
Sheet1

Cell Formulas
Range	Formula
B2:B6	B2	=AND(ISNUMBER(SEARCH({"APP ONLY","FOR QQ"},A2)))

THANK YOU THIS WORKED PERFECTLY!