Try
=LOOKUP(2,1/(A1:A65535<""),A1:A65535)

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

I want to reference the latest entry in a column. So that every time the
column is updated, and subsequently has another cell added to it, I don't
have to update the formula for referencing it.