User Profile
PaulaT1960
Copper Contributor
Joined Sep 17, 2019
User Widgets
Recent Discussions
A formula question
I have created a budget in Excel but want to streamline it. Each column is a particular budget item like Groceries, Gasoline, etc. I type in the name of the store, the date of purchase, and the method of payment in the 1st 3 columns. I then have to scroll many columns over to get to the column the budget amount goes in. This is time consuming since I have many budget columns. I would like to assign a code to each budget column then put that code in column 4 then the amount in column 5. My formula question is this. Is there a way to have Excel automatically put the amount I typed in column 4 in the correct budget column it is supposed to go in when it sees a specific code in column 3? I know how to do simple formulas like SUM but don't know how to do one this complex. I would love some input on this. Here is an example: Column #1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 Store / Date / Pay source / Code / Amount / Gasoline / Groceries / Electric /... PG&E / 11/1/23 / Ckg / 8 / 150.00 / / / 150.00 /929Views0likes1Comment
Recent Blog Articles
No content to show