error in index+match formula

Hello

i have a error in my formula
when i have a blank cell (D3 in example)
it should report the (last value-1) writed in line 3

please see example

Perhaps:

B5:
=LOOKUP(9,99E+307;$B3:INDEX($B3:$E3;MATCH(9,99E+307;$B3:$E3)-1))
=PROC(9,99E+307;$B3:ÍNDICE($B3:$E3;CORRESP(9,99E+307;$B3:$E3)-1))

B6:
=LOOKUP(9,99E+307;$B$3:$E$3)
=PROC(9,99E+307;$B$3:$E$3)

for B7 & B8 simply add a result vector ($B$2:$E$2) to the above

"it does not work" is helpful a post as you can imagine.

The formula does work so I suspect the issue is down either to delimiters, function translation and/or other inaccuracies.