I'm hoping to build a formula to automatially select a category based on select keywords/phrases from an imported bank statement. I attached an editable copy of the Google Sheet I'm looking for help with:
Under the 'Transactions' sheet, I have imported the first 3 transactions from my monthly bank statement. I would like to build a formula that can reference the 'Description' fields (Column D7 downwards) for select keywords/phrases. I was hoping the formula could populate the 'Category' in Column B automatically, either referencing the drop down menu or Column B in the 'Categories' sheet.
For example, based off the first 2 transactions:
If text from Column D in 'Transactions' sheet contains the phrase "Debit Google ADS", select category 'Advertising'.
If text from Column D in 'Transactions' sheet contains the keyword "Spotify", select category 'Music'.
I would like to create a series of these rules to autopopulate as many of these categories/transactions as possible, I'm just uncertain of the process or where to begin. Where would I even insert a formula for this type of rule?
I believe I'm looking to do something similar to this question: Categorize text in Google Sheets based on matching partial text in the Category index