Excel find two last non blank and non zero values

[zalik22]

Hi,

I am trying to find the last two data points that are not zero or blank. For the non-zero, I have

=IFERROR(INDEX(b6:b99,MATCH(0,b6:b99,0)-2),"-") to get the 2nd to last nonzero value.

=INDEX(b6:b99,MATCH(0,b6:b99,0)-1) to get the last nonzero value.

I have 2 other columns that have blank cells instead of 0 but the formulas above do not work. Is there a way I can edit the formulas so they work on cells that are blank (basically return the two cells above the first blank cell).

Thanks in advance!