Find a text in a sentence column

[rnola]

Hi,

I'm doing my first post here. Please excuse me if this is silly.

I have col A and col B as text fields. In col C I have a query list. I'm trying to find if the text values in both col A and col B exist anywhere in col C and then return a true or a false. Please see the attached sheet. Thank you gurus.

SEARCH TEXT.xlsx
	A	B	C	D
1	FACT_TABLE	CORE_TABLE	QUERY	OUTPUT
2	RESI_ADDR	EMP_DEMO	SELECT A.SAL, A.ADDR FROM EMP_DSI A GROUP BY 1,2	TRUE
3	COUNTY	EMP_QUAL	SELECT A.BAL, B.HLTH FROM EMP_FI A, EMP_SE B WHERE A.ID = B.ID	FALSE
4	EDUCATION	EMP_BIO	SELECT A.RESI_ADDR, A.LOC FROM EMP_DEMO A GROUP BY 1,2	FALSE
5
Sheet1

 

[Fluff]

Hi & welcome to MrExcel.
How about

=COUNTIFS(C:C,"*"&A2&"*",C:C,"*"&B2&"*")>0

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Find a text in a sentence column
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[rnola]

Hi & welcome to MrExcel.
How about

=COUNTIFS(C:C,"*"&A2&"*",C:C,"*"&B2&"*")>0

A big applause. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.