Searching rows above...

[Gus80]

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.

[Richard Buttrey]

Hi,

In E2 and copied down.

Please Login or Register  to view this content.

HTH

[Gus80]

Great

Thanks for your help mate.