find a word and return this in another cell

[stratis]

A B C D 1 Put Siemens Siemens 2 Long Singer Singer 3 Short Philips Philips 4 Cut Singer Delongi <colgroup><col><col><col span="2"></colgroup><tbody> </tbody>
I would like to find a formula that is searching the text in column B and if this formula finds a word from these that contained in column C, returns me this word in the relevant row in column D, for example. Thank you in advance!

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[njimack]

Excel Workbook
	B	C	D
1	Put Siemens	Siemens	Siemens
2	Long Singer	Singer	Singer
3	Short Philips	Philips	Philips
4	Cut Singer	Delongi
Sheet1

 

[stratis]

Thanks but in the last cell I want to appears "Singer"..To be more specific the formula must intetify if there is any word that contained in all the rows of column C..

 

[njimack]

Thanks but in the last cell I want to appears "Singer"..To be more specific the formula must intetify if there is any word that contained in all the rows of column C..

I don't understand. Can you post the expected result for all 4 rows?

 

[stratis]

A	B	C	D
1	Base Siemens	Siemens	Siemens
2	Long Singer	Singer	Singer
3	Short Philips	Philips	Philips
4	Cut Singer	Delongi	Singer

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

like this..

 

[njimack]

Excel Workbook
	B	C	D
1	Put Siemens	Siemens	Siemens
2	Long Singer	Singer	Singer
3	Short Philips	Philips	Philips
4	Cut Singer	Delongi	Singer
Sheet1

 

[stratis]

Thanks a lot!