google sheets - Return latest value within multiple single date rows

Question

So, the issue: I have a daily finances table, where I insert all incomings and outgoings every day. Every transaction creates a new line within the spreadsheet, so many rows will begin with the same date. What I need to do for a different spreadsheet (within the same doc) is to return the final sum on both bank accounts at the end of the day, so the latest added entry within the range of rows starting with the specific date (screenshot example: return the value from cell G20 for the 5th of January).

I've tried a rather simple version VLOOKUP, but it just returns randomly correct or incorrect results.

Here's a screenshot to explain the situation:

question from:https://stackoverflow.com/questions/65831454/return-latest-value-within-multiple-single-date-rows

Answer 1

Vlookup should work if the dates are in order, plz try

=vlookup(I2,{A2:A,G2:G},2,true)