Alright, rookie here, so I want to make a formula that says: if(B1=1, then put the number in A1 in D1, (if A2=2, then put the number in A1 in D2, (if A2=3 then...) and so on until A2=5
I hope that makes sense. Thank you in advance for any help.
Let's try this another way.
I have $ values from receipts in A1 and I want to cost code them in B1 (with the numbers 1-5) then send the number in A1 to say D1,2,3,4, or 5 based on the cost code. I want to make a pattern in columns A and B to add $ values and cost codes and if possible make the numbers go to D1,2,3,4 and 5 as running totals (i.e. keep adding everything that's cost coded "1" to cell D1).
Bookmarks