Forum Discussion
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 ...
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.