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!