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:
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 |