Mary,

=INDEX(Sheet2!A:A,MAX(IF(ISNUMBER(Sheet2!A1:A50),R OW(Sheet2!A1:A50)),1))

Array enter using Ctrl-Shift-Enter rather than just enter. Adjust each
instance of the 50 to give yourself more coverage.

HTH,
Bernie
MS Excel MVP

"Mary" wrote in message
...
I would like to show a list of the most up to date values
on a summary page in my workbook.

The value is always at the bottom of the same column and
it will be the lowest row with any numerical value.

How can I specify in my formula =m(lowestrowwithvalue)?

Thank you

Mary