Compare vale of A1 cell with B1 [Closed]

Report
-
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!