Hi all,
I'm working on some spending analysis and I'm struggling with the categorisation of transactions.
I've made a small sample example attached below. I've listed all the suppliers I expect to see transactions from in the 'Ref' sheet, and give each supplier a corresponding category from a finite drop down list.
image.png
In my 'Banking' sheet, I have complex descriptions in column B and I want a formula for cells in column D (Category) to tell me which category each transaction falls under based on key words/characters from the transaction description. To make this extra robust, i've thrown in some suppliers with concatenated endings so I assume wildcards (*) will be more appropriate than simply reading the entire string of supplier names.
Any help would be greatly appreciated.
Bookmarks