Ok I got your point
Use this array formula
=INDEX(A1:A44,MIN(IF(A10:A44="",ROW(A10:A44)-1,9^9)))

This is an array formula so after pasting this formula in the cell press ctrl+shift+enter instead of just enter as we usually do...by doing so you will get two curly braces like {} around the formula

Hope this helps