Return second to last non blank cell

Good morning all and Happy New Year!

I have a column of figures and want to return the last non-blank cell value, and second-to-last non-blank value.

The first part was easy enough to resolve using:

=LOOKUP(2,1/B5:B35,B5:B35)

Now, silly me, but I thought using an offset function would be a simple was of returning the second-to-last value. However, when I attempted to incorporate it into my original formula:

=OFFSET(LOOKUP(2,1/B5:B35,B5:B35),-1,0)

I get the 'the formula you entered contains an error' message. Am I missing something really obvious here?

Thanks

Steve