=LOOKUP(99^99,Sheet2!H:H)

will return last numeric in column H

=LOOKUP(2,1/(Sheet2!H1:H65535<""),Sheet2!H1:H65535)

will return the last anything from column H


Gord Dibben MS Excel MVP


On Thu, 7 Aug 2008 12:08:26 -0700, Gina wrote:

I have a workbook with several worksheets. Each of these worksheets has a
column (H) that has a running total. This total could be found in cell H3 or
H32, but the highest row# is always the current total.

Which function could I use in Sheet1 to return the current total of Sheet2?

Thank you !

Gina