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   Mar-10-2014
post by Dawn Thompson!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.


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