From what you say, I am not sure that you need a macro.
If A1 contains text to go in column C and B1 contains the text to find in column A,
then in cell C2 enter this formula:
=IF(A2=$B$1,$A$1,"")Drag the formula down in column C alongside the cells containing text in column A.
In this example, if cell A1 contains "Test" and B1 contains "String10" then any cell in column C on the same row as "String10" in a cell in column A, will contain "Test"