Latest value from table

  • Thread starter Thread starter WRC
  • Start date Start date
W

WRC

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.
 
Thanks.

What if its is text?



T. Valko said:
Assuming value means numeric value...

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

That will return the *last* numeric value from Sheet2 column A.
Click to expand...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Populate Data from a table to another 0
Excel Moving data to sheet2 from sheet1 0
How to get a value of data from the last rows of a table 4
if statement, change cell only if true 4
Compare identifier columns from 2 sheets - remove rows that are dups 2
Search Entire Sheet instead of 1? 4
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Copy from sheet to sheet when matches criteria 2

Back
Top