Highlighted
New Contributor

# Formula Issue

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

5 Replies
Highlighted

# Re: Formula Issue

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

# Re: Formula Issue

here is my document

Highlighted

# Re: Formula Issue

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

Highlighted

# Re: Formula Issue

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)

Highlighted

# Re: Formula Issue

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.