Keyword lookup from a list of keywords in a column of text descriptions

[swmicros]

I have an Excel database of invoice data with a text column for the description of the work performed. I need to identify (T/F in a column?) any invoice that has any keywords from a list in the description column. I have not yet created the list of keywords as I am not sure how they should be arranged, your suggestion will be welcomed.

How would I do that?

Simplified version of what I am after:

Book4
	A	B	C	D	E
1	Invoice	Description	T/F		Keyword list
2	15000	Sorted apples and put into boxes for Bill	F		register, cash, bagged, bag, bagging
3	15001	Worked the register for Suzy, who was out today for vacation.	T
4	15002	Worked produce with Bill	F
5	15003	Stocked shelves during night shift to help Ken	F
6	15004	helped at the cash register as per Bob	T
7	15005	brought in carts from parking lot on Friday	F
8	15006	Stocked produce shelves with Javier	F
9	15007	bagging at register, with Suzy	T
10	15008	Filled in in bakery dept on Sat, with Mary	F
Sheet1

 

[swmicros]

Peter,
Wanted to let you know I implemented your second formula in my invoice database and it is working perfectly. Thank you again.

 

[Peter_SSs]

Good news! Thanks for the update.