Monday, March 10, 2014

yogi_Pull The Value From The Last Populated Cell In A Column Using LOOKUP Function In Google New Sheets

                                         Google Spreadsheet   Post  #1556
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-10-2014
post by Dawn Thompson  https://productforums.google.com/forum/#!mydiscussions/docs/AyKWg7iMxpg)
How to return the last cell in a column form another sheet?
Hello, I am trying to import a sheet from Excel.  The equation below is supposed to return the last cell of a column in another sheet to a summary sheet.  There are no conditions other than that it be the last cell in the specified column.

=LOOKUP(2,1/('Sheet2'!F$1:F$65546<>""),'Sheet2'!F$1:F$65546)

The function works in Excel, but in Google Sheets it returns the first cell in the column instead of the last.
--------------------------------------------------------------------------
instead of checking for the large range of rows going from F1:F65536 for EXCEL, in the following illustration I used a small range of F1:F500 in Excel