Is there an expression to return value of last entry in a range?

[richard.leask]

I am probably just having a brain freeze but I can't figure out how to
create an expression that will return the last value entered in a
range of numbers. i.e. B5:B147 is a column where a new value is added
each day below the previous day's entry and I need to return the value
in the cell with the last (bottom) entry. Any suggestions?

 

[Domenic]

For the last numerical value, try...

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

For the last text value, try...

=LOOKUP(REPT("z",255),B5:B147)

Hope this helps!