If the ending balance is the *last* numeric value in a certain column...

Say your ending balance is the last numeric value in sheet1 column A:

=LOOKUP(1E100,Sheet1!A:A)

--
Biff
Microsoft Excel MVP


"endless_thoughts17" wrote in
message ...
I have a few worksheets that I do my budgeting and bills on. Is there a way
to reference by ending balance on a previous worksheet?