Lookup value

Hi Everyone,

Hope someone can help please

Column A

Marketing ABC
DCF Marketing
Sales DEF
HGF Sales

What I want is to look up column A and if it contains any value in Column C then return value in D

Column C------------Column D

Marketing------------Marketing Team
Sales-----------------Sales Team

So the result will look like this

Column A-------------Column B

Marketing ABC-------Marketing Team
DCF Marketing-------Marketing Team
Sales DEF------------Sales Team
HGF Sales------------Sales Team

It has to look for data in the table rather than multiple if functions otherwise it will be a very long if functions . Any suggestion is much appreciated.

Thanks

Kim