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