Pulling Last Balance

J

Jason P

One sheet (we'll call it "Savings") is a running balance of bank
transactions... no problem.

The next sheet is a sheet with the months of the year in Col. A.
Jan.
Feb.
Mar.
Etc.....

In Col. B I want to pull the last transaction from the Savings for that
month... however not to exceed the end of that month.

For instance, let's say I entered a deposit on 3/24/09 on Savings and my
balance is $100. The next transaction I entered is on 4/02/09 and my balance
is $200.
On Sheet 2 (Account Totals) I want $100 to correspond with the March column,
and $200 for the April column. Thus, I can chart ups and downs...

I tried:

=IF(
(VLOOKUP(SAVINGS!(DATEVALUE("4/01/09")), C3:H999, 6, 1)<(DATEVALUE("5/01/09"),
(VLOOKUP(SAVINGS!(DATEVALUE("4/01/09")), C3:H999, 6, 1),
"")

However, it's pulling the next month's info... because VLOOKUP is pulling
the next to highest number not equal to that month... the month before.

Any suggestions?
I'm rackin' my brain here.
 
J

Jason P

I tried something like this but all i keep getting is "son of a...", what I
entered if the statement was false... anything wrong with my syntax here?

=IF(AND
(INDEX(A20:G48,MATCH(DATEVALUE("3/01/2009"),A20:A999,-1),7))<(DATEVALUE("4/01/2009"))
(INDEX(A20:G48,MATCH(DATEVALUE("3/01/2009"),A20:A999,-1),7))>=(DATEVALUE("3/01/2009"))),
(INDEX(A20:G48,MATCH(DATEVALUE("3/01/2009"),A20:A999,-1),7)),
"son of a...")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing like data 5
Running Balance (Debit and Credit) in Access 2007 3
A vlookup/index-match type problem 10
Formula in excel 1
Selecting the latest record for transactions 4
Totals 11
Macro 3
Countif Function 3

Top