03-22-2020 01:36 PM
03-23-2020 06:47 AM - edited 03-23-2020 06:49 AM
The formula is working but the obstacle is that you have a duplicate date - the issue is that your VLOOKUP is set to FALSE (0), which returns the value pertaining to the first instance of the latest date. By changing the FALSE (0) in the VLOOKUP to TRUE (1), you will get the last instance of any duplicated latest date:
03-23-2020 08:51 AM - edited 03-23-2020 08:53 AM
As a variant, assuming that you enter transactions chronologically. Then you would always want to show the content of the right-most bottom corner in the table as your current balance. This formula will do exactly that. No need to look up dates as the latest entry will always be at the bottom of the table.
If my assumptions were wrong, kindly ignore my post.