latest value

[macker]

Hi,
This is probably a simple question.
I want to create a workbook with several sheets all detailiing the transactions in different financial accounts. I want the cover sheet to detail the latest balances in each of those accounts. Do I use some sort of Vlookup formula?
Any help would bee appreciated.

 

[Aladin Akyurek]

Hi,
This is probably a simple question.
I want to create a workbook with several sheets all detailiing the transactions in different financial accounts. I want the cover sheet to detail the latest balances in each of those accounts. Do I use some sort of Vlookup formula?
Any help would bee appreciated.

It's hard to visualize the lay-out you have. Care to elaborate referring to 2 sheets at most and the ranges involved?

 

[macker]

Sorry if I wasn't too clear.
Each sheet would list the debit and credit transactions and the balance on an account.
The cover sheet would just list the current balances on each account.

 

[Scott Huish]

=LOOKUP(9.9999999999999E+307,Sheet1!C:C)

Change sheet name and range to suit.

 

[macker]

Thank you, it works.