Lookup last date and return with result

[DHayes]

Good day,
I am struggling to put a formula together. I need to get the opening and closing from sheet1 (Below) and put it into sheet2. I need the balance from the last date but not later 2015-03-31. Some accounts the last date is in 2014. I need to do this for +- 23000 accounts. any assistance will be appreciated.

Invoice_Date		Account_No		Opening_Balance		Current_Balance
2014-01-16		100137/000239		208.62		418.90
2014-02-17		100137/000239		418.90		630.80
2014-03-18		100137/000239		630.83		208.60
2014-04-16		100137/000239		208.62		418.90
2014-05-19		100137/000239		418.90		630.80
2014-06-25		100137/000239		630.83		844.40
2014-07-29		100137/000239		844.40		1989.00
2014-08-24		100137/000239		1989.02		3136.10
2014-09-18		100137/000239		3136.11		4300.70
2014-10-20		100137/000239		4300.70		11845.20
2014-11-17		100137/000239		11845.21		12173.60
2014-12-17		100137/000239		12173.63		12504.00
2015-01-20		100137/000239		12504.00		12836.30
2015-02-17		100137/000239		12836.32		13170.55
2015-03-19		100137/000239		13170.59		13506.75
2015-04-19		100137/000239		13506.79		13844.90
2015-05-18		100137/000239		13844.94		4174.75
2015-06-28		100137/000239		4174.76		5346.00
2015-07-24		100137/000239		5346.04		6550.05
2015-08-19		100137/000239		6550.05		7765.25
2015-09-20		100137/000239		7765.25		8990.60

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Lapwing]

If the data is always in chronological order and the last transaction is in the final row; and there is only one account per tab then this will work: =LOOKUP(2,1/(A:A<>""),C:C)
Change C:C to D:D for the Current Balance.

 

[Lapwing]

Just noticed your restriction " but not later 2015-03-31." so my formula will not work.

This should do the trick: =LOOKUP(42094,A:A,C:C)
You could change the 42094 to a cell reference that had the max date in it.