Compare vale of A1 cell with B1

arun - Apr 8, 2015 at 12:24 AM

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 qqqq ->result sud be -> aaaa ->result sud be ->