Forum Discussion
TheJax
Dec 18, 2024Copper Contributor
Formula or Other Solution?
I have an accounting client who wants to have Excel automatically add a category to a transaction
He wants Excel to search B2 and if the word salary is found in any part of the field, place the word
INCOME in e2.
For B3, if Excel finds GMF in any part of the cell, add the "car payment" to the category.
Can this be done using a function or do you have an alternate method?
Thanks.
- NikolinoDEGold Contributor
Maybe, you can achieve this in Excel using an IF statement combined with the SEARCH function to automatically categorize transactions based on keywords found in the description. This method works well if you have a small list of keywords. Here's how you can do it:
=IF(ISNUMBER(SEARCH("salary", B2)), "INCOME", IF(ISNUMBER(SEARCH("GMF", B2)), "CAR PAYMENT", IF(ISNUMBER(SEARCH("Water", B2)), "UTILITY", IF(ISNUMBER(SEARCH("Transfer", B2)), "TRANSFER", ""))))
Hope this information can help you a little with your plans...if not, please just ignore it.