1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula needed to auto categorize budget

I want my budget to automatically categorize my transactions. I have a tab made up of all the different transactions that go through my bank account and next to each is the applicable category. I need a formula that will search the transaction list and enter the applicable categories.

This is my BUDGET tab. O is the column I would like to enter a formula in to automatically enter the category based on the information in N

https://preview.redd.it/6qtnudyd2lvg1.jpg?width=805&format=pjpg&auto=webp&s=463cd61c14c5f283791d3b375403844f994cd504

This is my LIST tab, within the same spreadsheet

https://preview.redd.it/ffu0ixc13lvg1.jpg?width=497&format=pjpg&auto=webp&s=8f4fbffe6031fa390c7fb275e9e3a3d0cc7b7118

Thank you in advance!

submitted by /u/Funkatronjive
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article