How to Lookup the Last Value from a Column or a Row in Excel. Excel offers two methods to lookup for the last value from a column or a row. Let’s discuss both formula types and learn when to use them. Lookup the Last Value (When the Last Value is in the Last Cell) To … Continue reading How to Lookup the Last Value from a Column or a Row in Excel