Another way...

=INDEX(A1:A7,ROWS(A1:A7)-1)


"SteveC" wrote:

How do I modify this:

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

which looks up the last value in a column so it instead retrieves the second
to last value in a column, third to last value in a column, fourth to last,
etc.

offset this value -1 somehow? or -2, -3 etc... not sure how to use OFFSET

thanks very much!