Vlookup or Index the last or 1st Non zero value

[peter8848]

Hi,

There are quite a bit of lookup last or 1st non zero value in a row or column as below link

http://www.xldynamic.com/source/xld.LastValue.html

Is there a way to combined it with vlookup, OR sum(if(criteria, if(criteria,range))), so we can search a range based on some row and column match to locate a particular row or column for its 1st or last non zero value?

Cheers,

Peter

 

[StephenCrump]

Yes, the techniques can be incorporated into bigger formulae.

But what are you trying to do?