Forum Discussion

TheJax's avatar
TheJax
Copper Contributor
Dec 18, 2024

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.

 

  • NikolinoDE's avatar
    NikolinoDE
    Gold 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.

Resources