Index Match on a random string, multiple possible criteria, results

[Yimmie]

I have a huge list of accounting entry descriptions (all are unique and hand typed) that need to be examined to determine treatment (1 of 3 possibilities). I built a keyword finder using IFERROR(INDEX(MATCH(ISNUMBER)))) that works great. It leverages a 2 column table with keywords and their treatment (1, 2, 3). I added an IFERROR to flag those with no keyword.

The problem is some entries include multiple keywords, and sometimes their treatments in the table conflict. Due to the randomness in what keywords may show up and in what order, I can't build that into the keyword table. The equation defaults the result to the first keyword it sees.

Is there a way to either auto-flag these accounting entries for further manual inspection or even merge multiple random keyword results in the output (such as it coming back with treatment "12", "31", "21", etc.?

Thanks in advance!

 

[Peter_SSs]

Welcome to the MrExcel board!

Something like this?

22 05 22.xlsm
	A	B	C	D	E	F
1					Keyword	Action
2	The mat is red	A2			cat	A1
3	The dog barked				mat	A2
4	The cat sat on the mat and ate the rat	A1, A2, A3			rat	A3
Keywords

Cell Formulas
Range	Formula
B2:B4	B2	=TEXTJOIN(", ",1,FILTER(F$2:F$4,ISNUMBER(SEARCH(" "&E$2:E$4&" "," "&A2&" ")),""))

 

[Yimmie]

Welcome to the MrExcel board!

Something like this?

22 05 22.xlsm
	A	B	C	D	E	F
1					Keyword	Action
2	The mat is red	A2			cat	A1
3	The dog barked				mat	A2
4	The cat sat on the mat and ate the rat	A1, A2, A3			rat	A3
Keywords

Cell Formulas
Range	Formula
B2:B4	B2	=TEXTJOIN(", ",1,FILTER(F$2:F$4,ISNUMBER(SEARCH(" "&E$2:E$4&" "," "&A2&" ")),""))

This worked perfectly. Thank you so much!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.