NorthMNGuy
New Member
- Joined
- Aug 22, 2019
- Messages
- 1
I'm trying to set up a table that has a date, then different expenses on each date.
Ultimately I would like to reference expenses on each day for specific expenses. Maybe the last 10 days of "Voids", a double vlookup that could find the date, then the void and return the column value.
There would be many more Ledger items, but this condensed. There would dozens more accounts than 1 checking.
I would be open to restructuring the information also.
[TABLE="width: 378"]
<colgroup><col width="126" span="3" style="width:95pt"> </colgroup><tbody>[TR]
[TD="width: 126"][/TD]
[TD="class: xl65, width: 126"]Ledger Item[/TD]
[TD="class: xl66, width: 126"]GF - Checking[/TD]
[/TR]
[TR]
[TD]First Vlookup[/TD]
[TD="class: xl71, align: right"]6/30/2019[/TD]
[TD="class: xl66"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Check Register[/TD]
[TD="class: xl69, align: right"](20,000.00)[/TD]
[/TR]
[TR]
[TD="class: xl70"]Second Vlookup[/TD]
[TD="class: xl63"]Voids[/TD]
[TD="class: xl67, align: right"]200.00 [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Deposits[/TD]
[TD="class: xl67, align: right"]1,600.00 [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Transfer IN[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Transfer OUT[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Item Fee[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]VISA Payment[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl64"]Total Balance[/TD]
[TD="class: xl68, align: right"]383,675.11 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl72, align: right"]7/1/2019[/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Check Register[/TD]
[TD="class: xl69, align: right"](86,501.05)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Voids[/TD]
[TD="class: xl67, align: right"]20,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Deposits[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer IN[/TD]
[TD="class: xl67, align: right"]30,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer OUT[/TD]
[TD="class: xl67, align: right"]10,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Item Fee[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]VISA Payment[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl64"]Total Balance[/TD]
[TD="class: xl68, align: right"]357,174.06 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl72, align: right"]7/2/2019[/TD]
[TD="class: xl68"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Check Register[/TD]
[TD="class: xl69, align: right"](104,694.95)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Voids[/TD]
[TD="class: xl67, align: right"]100.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Deposits[/TD]
[TD="class: xl69, align: right"]9,026.71 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer IN[/TD]
[TD="class: xl69, align: right"]70,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer OUT[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Item Fee[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]VISA Payment[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl64"]Total Balance[/TD]
[TD="class: xl68, align: right"]331,605.82 [/TD]
[/TR]
</tbody>[/TABLE]
Ultimately I would like to reference expenses on each day for specific expenses. Maybe the last 10 days of "Voids", a double vlookup that could find the date, then the void and return the column value.
There would be many more Ledger items, but this condensed. There would dozens more accounts than 1 checking.
I would be open to restructuring the information also.
[TABLE="width: 378"]
<colgroup><col width="126" span="3" style="width:95pt"> </colgroup><tbody>[TR]
[TD="width: 126"][/TD]
[TD="class: xl65, width: 126"]Ledger Item[/TD]
[TD="class: xl66, width: 126"]GF - Checking[/TD]
[/TR]
[TR]
[TD]First Vlookup[/TD]
[TD="class: xl71, align: right"]6/30/2019[/TD]
[TD="class: xl66"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Check Register[/TD]
[TD="class: xl69, align: right"](20,000.00)[/TD]
[/TR]
[TR]
[TD="class: xl70"]Second Vlookup[/TD]
[TD="class: xl63"]Voids[/TD]
[TD="class: xl67, align: right"]200.00 [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Deposits[/TD]
[TD="class: xl67, align: right"]1,600.00 [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Transfer IN[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Transfer OUT[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]Item Fee[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl63"]VISA Payment[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD="class: xl70"] [/TD]
[TD="class: xl64"]Total Balance[/TD]
[TD="class: xl68, align: right"]383,675.11 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl72, align: right"]7/1/2019[/TD]
[TD="class: xl69"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Check Register[/TD]
[TD="class: xl69, align: right"](86,501.05)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Voids[/TD]
[TD="class: xl67, align: right"]20,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Deposits[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer IN[/TD]
[TD="class: xl67, align: right"]30,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer OUT[/TD]
[TD="class: xl67, align: right"]10,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Item Fee[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]VISA Payment[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl64"]Total Balance[/TD]
[TD="class: xl68, align: right"]357,174.06 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl72, align: right"]7/2/2019[/TD]
[TD="class: xl68"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Check Register[/TD]
[TD="class: xl69, align: right"](104,694.95)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Voids[/TD]
[TD="class: xl67, align: right"]100.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Deposits[/TD]
[TD="class: xl69, align: right"]9,026.71 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer IN[/TD]
[TD="class: xl69, align: right"]70,000.00 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Transfer OUT[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]Item Fee[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl63"]VISA Payment[/TD]
[TD="class: xl67"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl64"]Total Balance[/TD]
[TD="class: xl68, align: right"]331,605.82 [/TD]
[/TR]
</tbody>[/TABLE]