Greetings everyone,

I just looking around and found on some other post a suggestion to
find the last value of a series of data in a column (Col E in this
case), which is:

=+LOOKUP(9.99999999999999E+307,E:E)

I'm trying to understand how this formula works; I read the help
file's content for the Lookup function and it is still not clear to me
how it works in this case. I'd appreciate if someone could explain
this to me. Thanks in advance!