Lookup the Last Value in a Column or Row in Excel

Microsoft Excel Tips and Tricks

In this video I demonstrate how to lookup the value in the last non-empty cell in a row or column in Excel. This can be achieved using the LOOKUP function.

Credit Chester Tugwell