Excel,=LOOKUP,HELP

I need a formula to display the last data in a column if that particular cell is blank, between set ranges of 48 in a column. THEN SEARCH BETWEEN A48 DOWN TO A1 AND DISPLAY THE LAST DATA IF NO DATA THEN DISPLAY NOTHING.

I can’t find the answer to this, can someone help?

Just found a solution without the if not data display nothing

=LOOKUP(48,1/(A1:A48<>“”),A1:A48)