I'm requesting some help with a formula quite sure it'll be simple for you all...

Situation:

Column J to R. Each row between these only has a title once (say if K4 has Manger VP all the others i.e J4, L4, M4, N4, O4, P4, Q4, R4 will be blank)

Formula required:

For every row on Column D (D4 onwards). I need to return the title in D4, D5, D6 and likewise.

Condition:

It should ignore the formula that returns the job title in columns J to R

My apologies for not posting an excel file. I understand it would have been all the more easier but due to some tech issues my internet isn't working so am using phone.

Thank you for the help!