Pulling Last Balance
 

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.

Pulling Last Balance
 

Are all the dates in the same year?

--
Biff
Microsoft Excel MVP


"Jason P" <Jason wrote in message
...
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.

Pulling Last Balance
 

No. Why would that matter?

"T. Valko" wrote:

Are all the dates in the same year?

--
Biff
Microsoft Excel MVP


"Jason P" <Jason wrote in message
...
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.

Pulling Last Balance
 

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...")



"Jason P" wrote:

No. Why would that matter?

"T. Valko" wrote:

Are all the dates in the same year?

--
Biff
Microsoft Excel MVP


"Jason P" <Jason wrote in message
...
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.