Looking back through cells in a column to find Specific Text

Thanks for that NBVC, so simple with the space instaed of null value, yet I could not see it for looking.
Appreciate the tidy up of the formula as well