Peco, et al.,

Got it figured out. I only needed the first half of that formula as I am not looking for a range, but a specific cell in the index.

=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-1)
=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-2)
=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-3)

etc...