Excel Forum
Similar Content
Excel VBA Check if a Cell is in a Range
Tutorial: VBA that checks if a cell is in a range, named range, or any kind of range, in Excel. Sec...
Get the Row or Column Number of a Cell in Excel
Tutorial: How to get the row or column number of the current cell or any other cell in Excel. This t...
Print Specific Rows or Columns on Each Page in Excel
Tutorial: How to repeat specific rows or columns on every printed page so that you know what each c...



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.