Excel Forum

Excel Magic Trick #176 Get Last Item in Column on Diff Sheet

See how to get the last number or word from a column on a different sheet. See how to use the LOOKUP, OFFSET, MAX and ROW functions, as well as an array formula. See the Big Number Theory of the LOOKUP function (BigNum = 9.99999999999999E+307).
See how to get the last value from column A from across multiple sheets using the LOOKUP and INDIRECT functions.

Got a Question? Ask it Here in the Forum.