Find and report list of words in excel

[sunny1985]

Hi All,

I am new to this forum hoping someone could help.

I have an excel like below

A B C

Man_is Human Man
Women_if Human Cat
Cat Animal
Dog Animal

I need to find the words from column C matched against Column A, If a match is found (Even part of it) return string in Column B.

Expected result is :

Man_is Human
Cat Animal

Please help me.

 

[godsaaint]

A B C

Man_is Human Man
Women_if Human Cat
Cat Animal
Dog Animal

Could you provide a better distributed table? This one confuses me.

 

[sunny1985]

Hi Godsaaint.

Column A: Man_is Women Cat Dog
Column B: Human Human Animal Animal
Column C: Man Cat

Expected output:

Column D: Man_is Human
Cat Animal

Hope this helps you understand the problem.

 

[Rick Rothstein]

Hi Godsaaint.

Column A: Man_is Women Cat Dog
Column B: Human Human Animal Animal
Column C: Man Cat

Expected output:

Column D: Man_is Human
Cat Animal

Hope this helps you understand the problem.

I am not sure of your "Column D" layout... how is what looks like two columns of output data (to me) supposed to fit in one column? It would be helpful if you downloaded the add-in shown in my signature line below and then post actual "pictures" of your cells so we can really see how the data and results are laid out.