Match entries in multiple columns

Hi all,

Please see the attached, I have tried (unsucessfully) to cross match three columns B,E & G to see if the entry in B is in the other two and to give a answer in column C. But I can't seem to get it right, can anyone please help a weary old so and so.

Cheers