Hello:

I want a formula to return the value of the last populated cell in a column.  In Excel and Google Sheets, the following formula works.

=LOOKUP(9.99E+307,F:F)

However, in Zoho, this formula returns the largest value in column F, not the last value.

  

Any ideas?  I appreciate any suggestions.  Thanks.

Scott