In column A I have companies, in column B I have titles, in column C, I have
names

Column A repeats companies, as there are a bunch of titles for each company.

In column D, I would like to return the name of the "Managing Director" for
each company (so it will be one name repeated for each company), based on
looking up the title in column B in combination with each unique company

eg
IBM, Director, Bob [in D, returned value = "Tim"]
IBM, Managing Director, Tim [in D, returned value = "Tim"]
IBM, Vice President, Mary [in D, returned value = "Tim"]
3M, Director, Sarah [in D, returned value = "Robyn"]
3M, Managing Director, Robyn [in D, returned value = "Robyn"]

Thanks in advance

Daniel