Compare vale of A1 cell with B1

Closed
arun - Apr 8, 2015 at 12:24 AM
Hello,

I want to know formula for the below problem.
I want to compare row A with row B and if part of B contains in A then display that particular cell in row C.


example

aaaa.cmp.com qqqq ->result sud be ->qqqq.cmp1.com
qqqq.cmp1.com aaaa ->result sud be -> aaaa.cmp.com