Forum Discussion
jojomartin845
May 01, 2026Copper Contributor
Put a specific word in a cell based on the word in another cell
Hey everyone, I need help automating the categorisation of my bank statement in excel. I do not have microsoft 365. I want excel to look for specific words from my transactions eg Woolworths or McD...
Kidd_Ip
May 02, 2026MVP
How about a lookup table of keywords and categories, by using formulas like VLOOKUP or INDEX/MATCH combined with SEARCH:
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://exceljet.net/formulas/categorize-text-with-keywords
https://www.extendoffice.com/documents/excel/7144-excel-categorize-bank-transactions.html