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
Lookup the Last Value in a Column or Row in Excel
