I made a mistake, sorry, i changed it and nothing came back. But this is due to the blank rows included. This will be the case, as there a blank rows with a formula inside, so what do I add to the formula?

=LOOKUP(REPT("Z";255);D:D)