Formula to get the last value in a range (not 0)

[RobbieC]

Hi there, I have a range (EF60:IV60) and I need to return the last value which is not blank or 0

I'm having a brain freeze moment...

I've tried:

=IFERROR(0,LOOKUP(2,1/(EF60:IV60<>""),EF60:IV60))

but it's not having it....

If you can point me in the right direction, I'd be most grateful

Thanks

 

[Marcelo Branco]

Maybe...

=IFERROR(LOOKUP(2,1/((EF60:IV60<>"")*(EF60:IV60<>0)),EF60:IV60),"Not found")

M.

 

[RobbieC]

Brilliant, thanks Marcelo! Monday morning!