Partial match vlookup in a sentence

Asked by At

Do you do a partial vlookup, searching for a word in a sentence? I have downloaded my bank statement CSV and the description of the payment is quite long-winded, I am looking to categorize each payment. In this example, I am looking to categorize 'Waitrose' as a 'Grocery' purchase.

Please feel free to try formula and make edits to the sheet, thanks!

1 Answers

player0 On Best Solutions
 TEXTJOIN("|", 1, Category!D2:D)), Category!D2:F, {1, 2, 3}, 0)))