Formula Issue

[Latrisa]

I got a formula for the current balance on performance sheet and tried to use on money sheet and it does not work can someone help me

[#2]

You need to attach your workbook sample for experts here to understand and help

[#3]

here is my document 

[#4]

@Latrisa 

Hello, I have seen your workbook but I don't understand the question clearly

[#5]

@Latrisa 

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:

=VLOOKUP(MAX($A:$A),A:G,7,1)

[#6]

@Latrisa 

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.

=INDEX(G:G,AGGREGATE(14,6,(ROW(G:G)*NOT(ISBLANK(G:G))),1),1)

 If my assumptions were wrong, kindly ignore my post.