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

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

Thanks.

What if its is text?



"T. Valko" wrote:

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

This version will return the *last* entry whether it's text or numeric. If
the last entry is a cell that contains a formula that retruns a formula
blank ("") that will be ignored.

=LOOKUP(2,1/(Sheet2!A1:A100<""),Sheet2!A1:A100)

Note that with this version you can't use entire columns as a range
reference unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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