Find any text from a cell in another one

[hnt007]

Hello and thanks for helping me out!

I have 2 cells:

- C2: Trumpet Piano Gtr Bass Violin Sax
- C3: Track description including trumpet piano Gtr bass violin

I'm looking for a formula to put, let's say, in C4, that will let me know if any of the words in C2 appears in C3, no matter the capitalizations. The tricky part is that I could have ANY instruments listed in C2, and it could be just 1 instruments listed, 2, 3, etc

 

[shift-del]

Hi

Mappe5
	C	D	E
2	Trumpet Piano Gtr Bass Violin Sax
3	Track description including trumpet piano Gtr bass violin
4
5	Trumpet	Track	WAHR
6	Piano	description
7	Gtr	including
8	Bass	trumpet
9	Violin	piano
10	Sax	Gtr
11		bass
12		violin
Tabelle1

Cell Formulas
Range	Formula
C5:C10	C5	=FILTERXML("<y><z>"&SUBSTITUTE(C2," ","</z><z>")&"</z></y>","//z")
D5:D12	D5	=FILTERXML("<y><z>"&SUBSTITUTE(C3," ","</z><z>")&"</z></y>","//z")
E5	E5	=SUM(COUNTIFS(D5#,C5#))>0
Dynamic array formulas.

 

[hnt007]

T

Hi

Mappe5
	C	D	E
2	Trumpet Piano Gtr Bass Violin Sax
3	Track description including trumpet piano Gtr bass violin
4
5	Trumpet	Track	WAHR
6	Piano	description
7	Gtr	including
8	Bass	trumpet
9	Violin	piano
10	Sax	Gtr
11		bass
12		violin
Tabelle1

Cell Formulas
Range	Formula
C5:C10	C5	=FILTERXML("<y><z>"&SUBSTITUTE(C2," ","</z><z>")&"</z></y>","//z")
D5:D12	D5	=FILTERXML("<y><z>"&SUBSTITUTE(C3," ","</z><z>")&"</z></y>","//z")
E5	E5	=SUM(COUNTIFS(D5#,C5#))>0
Dynamic array formulas.

Thank you for taking the time to help me out. but I'm on macOS and don't have this function FILTERXML