I have the following Data in Column A-

Column A
aman has email aman@gmail.com
tom has email tom@yahoo.com
John has email john@company.com
mike has email mike@industry.com

In column C I have the following data-

Column C
gmail
yahoo

I need to search for the text in Column C in the string of texts in Column A and return the following -

Column A Column B Column C
aman has email aman@gmail.com gmail yahoo
tom has email tom@yahoo.com yahoo gmail
John has email john@company.com
mike has email mike@industry.com


I have used the following query-

INDEX($C$1:$C$2,MATCH(1,COUNTIF(A1,"*"&$C$1:$C$2&" *"),0))

But it is giving me wrong result-

Column A Column B Column C
aman has email aman@gmail.com #N/A yahoo


tom has email tom@yahoo.com #N/A gmail
John has email john@company.com #N/A
mike has email mike@industry.com #N/A


Can someone please help.

It is not clear to me what you have in column A, column B and column C and what you want.