I have a spreadsheet of bank transactions and want to categorise them by type of shop. I'm trying to write a formula that would do something like the following for each transaction in the sheet: If the words 'asda, waitrose or tesco' are in column A write 'supermarket' in column B, If the words 'electric or phone' are in column A write 'utility' in column B, (and so on until I've covered all key words / categories).
Every month I would download that months bank transactions, add them to the bottom of the list and it would categorise the new ones.
Ideally the formula would be looking up the answers using a separate sheet so I can easily keep adding new shops / categories in the future.
I hope that makes sense! Thanks
Bookmarks