Offset function to find last value in range - with data gaps in range

[mizogy]

Hi All

I am aware you can use Lookup to find the last value in a range (which also takes into account the possibility of there being blank values in between the data points), however it does not work with the offset function. I want to use offset to return the Month End.

Any ideas?

Best, Mizogy

 

[Flaiban]

Would that be ?

=LOOKUP(2;1/(NOT(ISBLANK(B:B)));B:B)

 

[arthurbr]

OFFSET is a volatile function. Why would you want to use it if you can avoid it?