Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/Lookup-Last-Value-in-Column-or-Row.xlsx

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