Formula to find words from a list in cell

[Stuepef]

I have a list of words in a range and I would like to create a formula to see if those words are within a cell value. Rather than the formula saying TRUE or FALSE, I would like the formula to provide the actual word that it found OR a numeric value for where that words position is in the list (i.e. if the formula found the 3rd word in the list, then the formula would provide a 3)

Here is the data:

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Hafeez1982]

As you have 365 another option is

Fluff.xlsm
	D	E	F
1	List
2	Orange
3	Purple
4	Green
5	Blue
6	Maroon
7	Yellow
8	Light Green
9	Beige
10	Navy Blue
11
12	Cell
13	Orange Turbo Car		Orange
14	Orange Turbo Car		Orange
15	Orange Turbo Car		Orange
16	Orange Turbo Car		Orange
17	Purple Green Lambo		Purple, Green
18	Purple Lambo		Purple
19	Purple Lambo		Purple
20	Beige Seats		Beige
21	Beige Seats		Beige
22	Beige Seats		Beige
Sheet5

Cell Formulas
Range	Formula
F13:F22	F13	=TEXTJOIN(", ",,XLOOKUP(TEXTSPLIT(D13," "),$D$2:$D$10,$D$2:$D$10,""))

In this example let’s say when two values are returned such as “purple green” you want to return instead “data quality issue” how would you do this?

 

[Fluff]

As this is a different question it needs a new thread. Thanks