Searching rows above...

Hi Everyone

I am looking for a formula which will search rows above the current row until it reaches the first instance of the word "Directory" then return a cell from that row.

Please see attachment for an example.

Thanks for any help you can provide.