How to lookup last value in Microsoft excel

To look up the last value in a column or row in Excel, you can use the “LOOKUP” function with the “LAST” argument. The syntax for this function is:

=LOOKUP(LAST, range, return_range)

  • “LAST” is a special value that tells the function to find the last value in the specified range.
  • “range” is the range of cells that you want to search for the last value in.
  • “return_range” is the range of cells that you want to return a value from, based on the last value found in the “range” range.

For example, if you have a column of data in cells A1:A10, and you want to look up the last value in that column and return the corresponding value from column B, you would use the following formula:

=LOOKUP(LAST, A1:A10, B1:B10)

This will return the value from column B that corresponds to the last value in column A.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top