V LOOK UPS

I have a set of dates in the left column and transactions in the left.

 

I’m trying to write a formula that looks at the last date in the set and shows the transaction value for that date. Note that some transactions are on the same day so I’m looking for the very last value of that last date.

Secondly, I want the header for that cell to read ‘balance at’ and the date of that cell with the final transaction value.

 

By: Vanessa

Leave a Reply

Your email address will not be published. Required fields are marked *