Assuming value means numeric value...

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

That will return the *last* numeric value from Sheet2 column A.

--
Biff
Microsoft Excel MVP


"WRC" wrote in message
...
I have a table in sheet2 which I update (i.e. I keep adding the rows)
Summary of results in sheet1
Where I want the value from the last row of table from sheet2 to be shown.

Any function in excel

Thanks